SQL Server Central: Articles tagged T-SQL, Advanced Querying, SQL Server 2005

Introduction to Parameterization in SQL Server

In a previous article I showed how to look at what query plans are in SQL Server's memory. In this article I'll look at how they got there and how and when they get reused. This is commonly called compiling a query plan. More specifically I'll look at how and when SQL Server can parameterize dynamic SQL Read more...

By Additional Articles 2007/08/14 | Source: SQLTeam.com | Category: Performance Tuning

Rating:

Rate this |

Briefcase | 3,031 reads

Write PIVOT queries in SQL Server 2005

New to SQL Server 2005 is the PIVOT operator, which gives you the ability to rotate row level data into tabular data without the use of the CASE statement, as was necessary in previous versions of SQL Server. Read more...

By Additional Articles 2007/01/11 | Source: Builder.com | Category: Advanced Querying

Rating:

Rate this |

Briefcase | 4,597 reads

Using the OUTPUT Clause to Capture Identity Values on Multi-Row Insert

SQL Server 2005 introducted the OUTPUT clause which we can use to capture values from the inserted and deleted virtual tables. Read more...

By Additional Articles 2006/08/25 | Source: SQLTeam.com | Category: Advanced Querying

Rating:

Rate this |

Briefcase | 3,205 reads

Fast Text Processing in SQL Server

Processing text or long strings usually reduces SQL to a prosaic procedural language. Learn a few techniques for facilitating speedy text processing in SQL. Read more...

By Additional Articles 2006/05/10 | Source: DevX | Category: Advanced Querying

Rating:

Rate this |

Briefcase | 3,993 reads

Articles with tags T-SQL, Advanced Querying, SQL Server 2005

Refine your search with one of the following additional tags (with number of items):

Introduction to Parameterization in SQL Server

Write PIVOT queries in SQL Server 2005

Using the OUTPUT Clause to Capture Identity Values on Multi-Row Insert

Fast Text Processing in SQL Server