http://www.sqlservercentral.com/Content tagged T-SQL 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/T-SQL does some things wonderfully, but cursors are the bane of the language, often causing performance issues. Changing your queries around to remove cursors can be tricky and new author Kamran Ali brings us one technique he has used to dramatically improve performance. http://www.sqlservercentral.com/articles/SQL+Puzzles/eliminatingcursors/2223/2006/07/21http://www.sqlservercentral.com/articles/SQL+Puzzles/eliminatingcursors/2223/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/A function to calculate the date for Easter Sunday for a given yearhttp://www.sqlservercentral.com/scripts/T-SQL/62633/2008/03/24http://www.sqlservercentral.com/scripts/T-SQL/62633/In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries. http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/2006/06/02http://www.sqlservercentral.com/articles/Performance+Tuning/temptabl/662/This a function by which you can calculate the age of something.http://www.sqlservercentral.com/scripts/T-SQL/62794/2008/04/10http://www.sqlservercentral.com/scripts/T-SQL/62794/It's a well known fact that there's no such thing as a true "array" in SQL Server and that you can't pass a table as a parameter... but you can get a lot closer than you think.http://www.sqlservercentral.com/articles/T-SQL/63003/2008/05/02http://www.sqlservercentral.com/articles/T-SQL/63003/Here is a short UDF to URL encode a string. Requires a numbers table.http://www.sqlservercentral.com/scripts/URL/62679/2008/03/27http://www.sqlservercentral.com/scripts/URL/62679/http://www.sqlservercentral.com/questions/T-SQL/62803/2008/04/10http://www.sqlservercentral.com/questions/T-SQL/62803/This article illustrates different methods to insert data into a table, including the new Row Value Constructor, which simplifies the data insertion.http://www.sqlservercentral.com/redirect/articles/63015/2008/05/16http://www.sqlservercentral.com/redirect/articles/63015/One of the very common questions posted about T-SQL is how to traverse a hierarchy in a set based manner. New author Craig Hatley brings us his techniques for handling the common scenario of employees and managers. http://www.sqlservercentral.com/articles/Advanced+Querying/3001/2008/05/16http://www.sqlservercentral.com/articles/Advanced+Querying/3001/http://www.sqlservercentral.com/questions/T-SQL/62843/2008/05/14http://www.sqlservercentral.com/questions/T-SQL/62843/http://www.sqlservercentral.com/questions/T-SQL/62798/2008/05/13http://www.sqlservercentral.com/questions/T-SQL/62798/One developer's journey through PIVOTing incorrectly.http://www.sqlservercentral.com/articles/pivot/62808/2008/05/13http://www.sqlservercentral.com/articles/pivot/62808/http://www.sqlservercentral.com/questions/T-SQL/62815/2008/05/07http://www.sqlservercentral.com/questions/T-SQL/62815/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/http://www.sqlservercentral.com/questions/T-SQL/62806/2008/05/05http://www.sqlservercentral.com/questions/T-SQL/62806/In the first article of a new series on T-SQL tips, Jacob Sebastian brings us a very useful technique. How to pass a table to a stored procedure so some set of rows can be operated on using some business logic. http://www.sqlservercentral.com/articles/Stored+Procedures/2977/2008/05/02http://www.sqlservercentral.com/articles/Stored+Procedures/2977/Longtime SQL Server DBA and author Grant Fritchey decided to quiz his developers on how to perform some simple functions in T-SQL. Read about his results and see how you might do in taking his quiz. http://www.sqlservercentral.com/articles/SQL+Puzzles/2973/2008/05/01http://www.sqlservercentral.com/articles/SQL+Puzzles/2973/This article describes and demonstrates the problem of using asterisk to select all fields from a table within a table function.http://www.sqlservercentral.com/articles/UDF/62730/2008/04/30http://www.sqlservercentral.com/articles/UDF/62730/In which Phil takes a break from a tedious bit of routine coding to build a Spam Filter in SQL.http://www.sqlservercentral.com/redirect/articles/62837/2008/04/25http://www.sqlservercentral.com/redirect/articles/62837/In an interesting exercise in data conversion, Stephen Lasham brings us a nice article on basic manipulations. http://www.sqlservercentral.com/articles/Advanced+Querying/2969/2008/04/25http://www.sqlservercentral.com/articles/Advanced+Querying/2969/http://www.sqlservercentral.com/questions/T-SQL/62758/2008/04/25http://www.sqlservercentral.com/questions/T-SQL/62758/This article illustrates the functionality of UPSERT via the MERGE command in SQL Server 2008.http://www.sqlservercentral.com/redirect/articles/62835/2008/04/24http://www.sqlservercentral.com/redirect/articles/62835/One of the issues I have is that the SQL Server Error Log is quite large and it is not always easy to view the contents with the Log File Viewer. In a previous tip "Simple way to find errors in SQL Server error log" you discussed a method of searching the error log using VBScript. Are there any other easy ways to search and find errors in the error log files?http://www.sqlservercentral.com/redirect/articles/62839/2008/04/23http://www.sqlservercentral.com/redirect/articles/62839/Robyn and Phil go back to basics and hammer out some basic String-handling User Functions in TSQL, based on Python examples. Plenty of sample code, and TSQL programming tricks.http://www.sqlservercentral.com/redirect/articles/62836/2008/04/22http://www.sqlservercentral.com/redirect/articles/62836/How to remove duplicate records from a table.http://www.sqlservercentral.com/scripts/T-SQL/62352/2008/04/18http://www.sqlservercentral.com/scripts/T-SQL/62352/Tool to automatically query combinations of columns in your table to determine candidate for unique key.http://www.sqlservercentral.com/scripts/T-SQL/62086/2008/04/16http://www.sqlservercentral.com/scripts/T-SQL/62086/http://www.sqlservercentral.com/questions/T-SQL/62594/2008/04/15http://www.sqlservercentral.com/questions/T-SQL/62594/QL 2005 adds two new methods – signing with certificates and impersonation with EXECUTE AS – that can manage cases where the classic method of ownership chaining fails. I explain the two new methods, as well as the old one, and warns you about the pitfalls.http://www.sqlservercentral.com/redirect/articles/62314/2008/04/15http://www.sqlservercentral.com/redirect/articles/62314/