SQLServerCentral.com Content tagged Advanced Querying, SQL Server 2005http://www.sqlservercentral.com/Content tagged Advanced Querying, SQL Server 2005 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Delimited String Parsing Functions - TwoCol setFeed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63962/2008/11/03http://www.sqlservercentral.com/scripts/T-SQL+Aids/63962/Delimited String Parsing Functions - Big2D setFeed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63961/2008/10/22http://www.sqlservercentral.com/scripts/T-SQL+Aids/63961/Delimited String Parsing Functions - Basic SetFeed it delimited horizontal data and it returns it back as a vertical table.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63958/2008/10/20http://www.sqlservercentral.com/scripts/T-SQL+Aids/63958/Delimited String Parsing Functions - 2D setFeed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63960/2008/10/14http://www.sqlservercentral.com/scripts/T-SQL+Aids/63960/Delimited String Parsing Functions - Big SetFeed it large strings of delimited horizontal data and it returns it back as a vertical table.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63959/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63959/Counter Table (table of numbers) Setter-Upper for SQL Server 2005Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63957/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63957/A Sudoku solution with set based T-SQL utilizing binary operators.A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.http://www.sqlservercentral.com/scripts/T-SQL/62978/2008/06/09http://www.sqlservercentral.com/scripts/T-SQL/62978/Introduction to Parameterization in SQL ServerIn 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 http://www.sqlservercentral.com/redirect/articles/3155/2007/08/14http://www.sqlservercentral.com/redirect/articles/3155/Write PIVOT queries in SQL Server 2005New 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.http://www.sqlservercentral.com/redirect/articles/2791/2007/01/11http://www.sqlservercentral.com/redirect/articles/2791/Using the OUTPUT Clause to Capture Identity Values on Multi-Row InsertSQL Server 2005 introducted the OUTPUT clause which we can use to capture values from the inserted and deleted virtual tables.http://www.sqlservercentral.com/redirect/articles/2555/2006/08/25http://www.sqlservercentral.com/redirect/articles/2555/Fast Text Processing in SQL ServerProcessing text or long strings usually reduces SQL to a prosaic procedural language. Learn a few techniques for facilitating speedy text processing in SQL. http://www.sqlservercentral.com/redirect/articles/2401/2006/05/10http://www.sqlservercentral.com/redirect/articles/2401/