http://www.sqlservercentral.com/Content tagged T-SQL, SQL Server 2005, Advanced Querying posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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/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 http://www.sqlservercentral.com/redirect/articles/3155/2007/08/14http://www.sqlservercentral.com/redirect/articles/3155/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.http://www.sqlservercentral.com/redirect/articles/2791/2007/01/11http://www.sqlservercentral.com/redirect/articles/2791/SQL 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/Processing 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/