http://www.sqlservercentral.com/Content tagged T-SQL, SQL Server 2005 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.http://www.sqlservercentral.com/scripts/Miscellaneous/63094/2008/05/13http://www.sqlservercentral.com/scripts/Miscellaneous/63094/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/04/30http://www.sqlservercentral.com/scripts/T-SQL/62978/Learn what a Dates table is and how to create one, and then try it out for yourselfhttp://www.sqlservercentral.com/redirect/articles/62914/2008/05/06http://www.sqlservercentral.com/redirect/articles/62914/This allows a player to play tic tac toe against an automated computer.http://www.sqlservercentral.com/scripts/TSQL/62384/2008/03/11http://www.sqlservercentral.com/scripts/TSQL/62384/Parses up & down the dependency chain of an objecthttp://www.sqlservercentral.com/scripts/T-SQL/61941/2008/02/26http://www.sqlservercentral.com/scripts/T-SQL/61941/Working with large images or other BLOB data can be a challenge for many DBAs. Andrew Sears brings us some code that can help you extract some of that data out of BLOBs and get it back into a more easy-to-work-with format.http://www.sqlservercentral.com/articles/T-SQL/61679/2008/01/30http://www.sqlservercentral.com/articles/T-SQL/61679/This Script generates drop and create scripts for views or stored procedures.http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61340/2008/01/14http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61340/Learn one of the techniques for calculating percentiles with SQL Server 2005 using the new SQL Server Common Table Expression and the latest ROW_NUMBER function. http://www.sqlservercentral.com/redirect/articles/61417/2007/11/15http://www.sqlservercentral.com/redirect/articles/61417/A look at how constants are used in T-SQL and SQL Server in general along with some suggestions on how better to deal with them.http://www.sqlservercentral.com/articles/T-SQL/61244/2007/10/16http://www.sqlservercentral.com/articles/T-SQL/61244/http://www.sqlservercentral.com/questions/T-SQL/61237/2007/10/08http://www.sqlservercentral.com/questions/T-SQL/61237/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/In the fourth installment of this series, Jacob Sebastian moves on to SQL Server 2005 and the new XML capabilities that make working with XML data easier than ever. http://www.sqlservercentral.com/articles/Stored+Procedures/2912/2007/04/05http://www.sqlservercentral.com/articles/Stored+Procedures/2912/Grant Fritchey steps into the workbench arena, with an example-fuelled examination of catching and gracefully handling errors in SQL 2000 and 2005, including worked examples of the new TRY..CATCH capabilities.http://www.sqlservercentral.com/redirect/articles/2883/2007/03/06http://www.sqlservercentral.com/redirect/articles/2883/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/Have you been burned by sysdepends at some point in your SQL Server DBA career? Steve Jones has many times, but a FREE new utility ends all that. http://www.sqlservercentral.com/articles/Miscellaneous/fixingsysdepends/2094/2005/09/22http://www.sqlservercentral.com/articles/Miscellaneous/fixingsysdepends/2094/