SQL Server Articles
Who is online?
128
guests and
0
members
Login
|
Register
home
articles
forums
blogs
did-you-know
quick tip
podcasts
files
login
about us
events
join us
write for us
register
Create a new article
home
»
articles
SQLServerGeeks.com Articles
Email Subscriptions
Get Recent Blogs in your inbox
Quick Vote
Do you have a SQL Monitoring Tool in your organization\client site?
8
Yes
No
Most Recent Articles
Email
SQL Server - XML Data Type Methods – Part 2
The nodes () method returns a row set representation of the XML document. The nodes () method is useful when you want to shred an xml data type instance into relational data. It also allows you to identify nodes that will be mapped into a new row. Every x...
tags :
SQL Server
,
XML Methods in SQL Server
,
exist()
,
modify()
,
nodes()
,
query()
Piyush Bajaj
- 9/7/2011 3:16:19 PM - Comments:
0
- Views: 13628
Email
SQL Server - XML Data Type Methods - Part 1
XPath is used for locating XML elements and attributes within an XML document and locating through the XML tree. Every element and attribute within an XML document has a unique “path”.
tags :
SQL Server
,
Value()
,
XML Methods in SQL Server
,
XPath
Piyush Bajaj
- 9/7/2011 3:15:54 PM - Comments:
0
- Views: 12752
Email
SQL Server – INSTEAD OF and AFTER Triggers
INSTEAD OF trigger causes the INSERT, UPDATE, or, DELETE operation to be cancelled. Due to this the SQL command submitted to SQL Server is discarded by the INSTEAD OF trigger. In-fact the code within the INSTEAD OF trigger is executed instead of the submi...
tags :
SQL Server
,
AFTER Trigger
,
INSTEAD OF Trigger
Piyush Bajaj
- 9/7/2011 3:15:17 PM - Comments:
2
- Views: 28642
Email
SQL Server – Globally Unique Identifiers (GUIDs)
Globally Unique Identifier’s are sometimes used as Primary Keys. GUIDs are in-fact the best choice in replicated scenarios, when you have to generate unique values at different locations. GUIDs are being generated by the SQL code or by a column default, r...
tags :
SQL Server
,
GUID
,
NEWSEQUENTIALID()
,
What is GUID in SQL Server
Piyush Bajaj
- 9/7/2011 3:14:54 PM - Comments:
2
- Views: 22965
Email
SQL Server - Windowing and Ranking – Part 3
RANK () functions: The RANK functions return values as if rows were competing according to the windowed sort order. The ties are being grouped together with the same ranked value. It returns the rank of each row within the partition of a result set. The s...
tags :
SQL Server
,
Ranking Functions
,
DENSE_RANK
,
NTILE
,
RANK
Piyush Bajaj
- 9/7/2011 3:12:57 PM - Comments:
0
- Views: 31759
Email
SQL Server - Windowing and Ranking – Part 2
The ROW_NUMBER () function generates an auto-incrementing integer according to the sort order of the OVER () clause. It returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition. The row n...
tags :
SQL Server
,
Ranking Functions
,
Row Number
,
ROW_NUMBER
,
What is Ranking Functions in SQL Server
Piyush Bajaj
- 9/7/2011 3:12:26 PM - Comments:
0
- Views: 25194
Email
SQL Server - Windowing and Ranking – Part 1
The windowing provides a new perspective on the data, while the ranking functions then use that perspective to provide additional ways to manipulate the query results. Windowing: The Windows have to be applied before the Ranking functions in the Query. It...
tags :
SQL Server
,
What is Windowing in SQL Server
,
Windowing
Piyush Bajaj
- 9/7/2011 3:11:59 PM - Comments:
2
- Views: 3606
Email
SQL Server - Building CrossTab Queries – PART 3
It can also be seen as inverse of a crosstab query, which is extremely useful for normalizing denormalized data. It does this by twisting the data back to a normalized list, i.e., clockwise 90 degree. The UNPIVOT can only normalized the data supplied to i...
tags :
SQL Server
,
PIVOT
,
UNPIVOT
Piyush Bajaj
- 9/7/2011 3:11:04 PM - Comments:
2
- Views: 11337
Email
SQL Server - Building CrossTab Queries – PART 2
The CASE expression method initiates with a normal GROUP BY query generating a row for each value in the GROUP BY column. Therefore, adding a ROLLUP function to the GROUP BY adds a nice grand totals row to the crosstab. The main function of the CASE expre...
tags :
SQL Server
,
Case Expression Method
,
Dynamic Columns in SQL Server
,
Dynamic Crosstab Queries
Piyush Bajaj
- 9/7/2011 3:10:38 PM - Comments:
1
- Views: 26128
Email
SQL Server - Building CrossTab Queries – PART 1
The Cross-tabulation, or Crosstab, query pivots the second GROUP BY column (or dimension) values counterclockwise 90 degrees and turns it into the crosstab columns. Although the columnar GROUP BY query can have multiple aggregate functions, a crosstab que...
tags :
SQL Server
,
PIVOT
,
What is PIVOT method in SQL Server
Piyush Bajaj
- 9/7/2011 3:09:50 PM - Comments:
2
- Views: 21894
Email
SQL Server: ROLLUP and CUBE. Is it Same?
The ROLLUP and CUBE aggregate functions generate subtotals and grand totals as separate rows, and supply a null in the GROUP BY column to indicate the grand total. ROLLUP generates subtotal and total rows for the GROUP BY columns. CUBE extends the capabil...
tags :
SQL Server
,
Cube in SQL Server
,
Rollup in SQL Server
Piyush Bajaj
- 9/7/2011 3:09:14 PM - Comments:
0
- Views: 26369
Email
SQL Server – What is Common Table Expression (CTE)?
The Common Table Expression (CTE) was introduced earlier in the SQL Server 2005. The CTE defines about a temporary view, which can be referenced just like a view in the same query. The CTE’s can be used in the same ways that simple Subqueries are used and...
tags :
Common Table Expression (CTE) in SQL Server
,
CTE
,
How to create CTE in SQL Server
,
How to use CTE in SQL Server
Piyush Bajaj
- 9/7/2011 3:08:09 PM - Comments:
2
- Views: 60305
Email
SQL Server - How to Merge Data with JOINS? – PART 3
This article post is all about Self Join and Cross Join, why do we need it? What are the relations involved in this? Self-Joins: A Self-Join is a join that refers to the same table. Use a self-join when you want to create a result set that joins records i...
tags :
Joins
,
What is Cross Join in SQL Server
,
What is Self Join in SQL Server
Piyush Bajaj
- 9/7/2011 3:06:49 PM - Comments:
0
- Views: 105422
Email
SQL Server - How to Merge Data with JOINS? – PART 2
Outer Join: Outer Joins extends the inner join by adding the non-matching data from the left, or right, or from both side data sets. Outer Joins solves a significant problem for many queries by including all the data regardless of a match. This not only i...
tags :
What is Right Outer Join in SQL Server
,
What is Left Outer Join in SQL Server
,
What is Outer Join in SQL Server
Piyush Bajaj
- 9/7/2011 3:06:00 PM - Comments:
2
- Views: 55780
Email
SQL Server - How to Merge Data with JOINS? – PART 1
Join is basically a multiplication of two data sets followed by a restriction of the result so that only the intersection of the two data sets is returned. The main function of Join is to horizontally merge two data sets and produce a new result set from ...
tags :
How to use Inner Join in SQL Server
,
Inner Join
,
What is Inner Join in SQL Server
Piyush Bajaj
- 9/7/2011 3:03:27 PM - Comments:
3
- Views: 21528
Email
Installation Guide for SQL Server 2008 R2
Here is the Installalation Guide for SQL Server 2008 R2 which comprises of 24 steps.
tags :
How to install SQL Server 2008 R2
,
Installation Guide of SQL Server 2008 R2
,
Installing SQL Server 2008 R2
Piyush Bajaj
- 9/7/2011 3:01:48 PM - Comments:
2
- Views: 22543
Email
SQL Server - What Is A Cursor?
Cursors are database objects used to manipulate data in a set on a row-by-row basis; it acts just like a recordset in ASP and Visual Basic. We can also fetch cursor rows and perform operations on them in a loop just like using any looping mechanism found ...
tags :
SQL Server
,
Cursor
,
ISO Syntax
,
Transact-SQL Syntax
Piyush Bajaj
- 9/7/2011 2:56:56 PM - Comments:
3
- Views: 21961
Email
SQL Server- Union and Union All, it’s not the same stuff
Union and Union all is the command being used to combine the results of the two query. Union is basically being used for the unique rows while Union All is being used for iterative rows to occur or where its not a mandatory issue. So based on this i have ...
tags :
SQL Server
,
Union
,
Union All
,
What is the difference between Union and Union All
Piyush Bajaj
- 9/7/2011 2:53:37 PM - Comments:
2
- Views: 10357
Email
SQL Server- Different RAID Levels
RAID stands for Redundant Array of Inexpensive Disks. It is a category of disk drives that utilizes two or more drives in combination for increased performance and fault tolerance. RAID applications are typically found in high-performance disk systems uti...
tags :
RAID
,
RAID levels
,
RAID in SQL Server
,
RAID levels in SQL Server
Piyush Bajaj
- 9/7/2011 2:52:44 PM - Comments:
4
- Views: 2737
Email
SQL Server - Installation Guide for Denali CTP 3
You might have been wondering about the proper steps for the installation of Denali CTP 3. Well, you don’t have to worry anymore. I am going to give you some heads up: Once the installation plan has been created and the server is et up to meet the SQL Ser...
tags :
SQL Server
,
Denali
,
Denali CTP3
,
How to install Denali CTP 3
Piyush Bajaj
- 8/18/2011 6:14:37 AM - Comments:
1
- Views: 45012
Email
Adding Custom Reports in SQL Server 2005 Performance Dashboard
This article shows how we can design our own custom dashboard reports and use them in SQL Server Management Studio.
tags :
Custom Reports
,
Performance Dashboard Reports
Amit Karkhanis
- 7/13/2011 6:22:05 AM - Comments:
10
- Views: 10349
Email
Using SQL Server Reporting Services to Manage Data
This article demostrates a way of using reporting services to insert / update / delete data.
tags :
Manage data using SSRS
,
SSRS as a data entry tool
,
Insert Data Using Reporting Services
Amit Karkhanis
- 7/13/2011 6:21:53 AM - Comments:
10
- Views: 8180
Email
New Date and Time Data Types in SQL Server 2008
Introduction to new Date and Time data types introduced in SQL Server 2008.
tags :
Data Types
,
DateTime
,
SQL Server 2008
Arjit Malviya
- 4/20/2011 11:31:59 AM - Comments:
3
- Views: 2029
Email
Cell level Encryption in SQL server
Ways to implement Cell level encryption in SQL Server
tags :
Cell Level Encryption SQL Server
,
Encryption SQL Server
Sachin Nandanwar
- 4/18/2011 3:02:21 PM - Comments:
4
- Views: 8735
Email
User & Schema separated in SQL Server 2005
As we know Schemas are very important in SQL Server. They play an important part in names of objects, Schemas work like container and contain DB Objects and they are securable. Due to the separation of users and schemas in SQL Server, many functions, desi...
tags :
Login
,
Schema
,
User
Sarabpreet Anand
- 4/18/2011 3:02:01 PM - Comments:
1
- Views: 7757
Page 3 of 4 (77 items)
<< Prev
1
2
3
4
Next >>
Go to page:
[Go]