http://www.sqlservercentral.com/Content tagged T-SQL, Miscellaneous 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/What is the fastest way to update a newly created column in a large table? New author Bimal Fernando brings us a look at a technique he uses for just this situation. http://www.sqlservercentral.com/articles/Miscellaneous/2954/2008/04/07http://www.sqlservercentral.com/articles/Miscellaneous/2954/This procedure prepares a query for generating permutations of n-numbers set and executes it.http://www.sqlservercentral.com/scripts/Miscellaneous/62164/2008/03/18http://www.sqlservercentral.com/scripts/Miscellaneous/62164/Have you ever wanted to ensure that keywords in your data are easily searchable? Have you struggled with full-text search? New author Michael Ahmadi brings us an interesting idea for a keyword tracking and searching subsystem based on T-SQL and triggers. http://www.sqlservercentral.com/articles/Miscellaneous/2875/2008/02/21http://www.sqlservercentral.com/articles/Miscellaneous/2875/When automating administrative actions for SQL Server, there are a number of ways to handle the workflow. Longtime SQL Server DBA Roy Carlson brings us a technique for using a text file as input to the standard SQL Server tools. http://www.sqlservercentral.com/articles/Miscellaneous/2801/2008/01/14http://www.sqlservercentral.com/articles/Miscellaneous/2801/The use of bitmasking is usually limited to decoding values in the system views, but it can be useful in other places when you want to save space. New author Lee Everest brings us an introduction to bitmasking and its use in SQL Server 2005. http://www.sqlservercentral.com/articles/Miscellaneous/2748/2007/12/05http://www.sqlservercentral.com/articles/Miscellaneous/2748/SQL Server 2008 is well on its way to being complete and released with the release of the second CTP recently. There aren't a tremendous number of changes, but one of the more interesting ones is the changes to date and time handling in this new platform. The time and date datatypes have been separated and longtime SQL Server author Vincent Rainardi brings us a short look at how there can be used.http://www.sqlservercentral.com/articles/News/3253/2007/10/24http://www.sqlservercentral.com/articles/News/3253/Continuing with his series on Alias Data Types, Yakov Shlafman shows us how to work wtih ADTs when constriaints are involved. http://www.sqlservercentral.com/articles/Miscellaneous/3213/2007/09/03http://www.sqlservercentral.com/articles/Miscellaneous/3213/The SQL Server Tables and Exchange Web Services sample demonstrates a powerful integration of Microsoft® Exchange Server 2007 and Microsoft SQL Server™ 2005 features. This integration enables you to provide data from both Microsoft Exchange and SQL Server to client applications so that the data appears as if it were stored in SQL Server. As you will see, this creates some exciting development scenarios.http://www.sqlservercentral.com/redirect/articles/3042/2007/06/22http://www.sqlservercentral.com/redirect/articles/3042/What is the fastest way to update a newly created column in a large table? New author Bimal Fernando brings us a look at a technique he uses for just this situation. http://www.sqlservercentral.com/articles/Miscellaneous/2954/2008/04/07http://www.sqlservercentral.com/articles/Miscellaneous/2954/Have you ever wanted to ensure that keywords in your data are easily searchable? Have you struggled with full-text search? New author Michael Ahmadi brings us an interesting idea for a keyword tracking and searching subsystem based on T-SQL and triggers. http://www.sqlservercentral.com/articles/Miscellaneous/2875/2008/02/21http://www.sqlservercentral.com/articles/Miscellaneous/2875/New Author! Deadlocks aren't the most common problem but they happen they can really degrade performance. Shiv works through how to nail down what is causing the deadlock. http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/tracingdeadlocks/1324/2007/04/06http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/tracingdeadlocks/1324/In the previous articles, Jacob Sebastian looked at using XML to save a sales order with variable numbers of line items to a SQL Server 2000 database. In this part, he expands upon the processing to access that data from multiple nodes. http://www.sqlservercentral.com/articles/Miscellaneous/2911/2007/04/03http://www.sqlservercentral.com/articles/Miscellaneous/2911/In the first part of this series, Jacob Sebastion showed us how to use XML to save a sales order to the database with a variable amount of line items. In part 2, he continues looking at XML in SQL Server 2000 with some advanced XML processing. http://www.sqlservercentral.com/articles/Miscellaneous/2909/2007/03/29http://www.sqlservercentral.com/articles/Miscellaneous/2909/How many times have you tried to save a sales order to your database? For many DBAs this is a common scenario and one of the challenges is the many round trips for the various line items. Jacob Sebastian brings us the first part of a four part series looking at how you can use XML to reduce the round trips in SQL Server 2000. http://www.sqlservercentral.com/articles/Miscellaneous/2908/2007/03/27http://www.sqlservercentral.com/articles/Miscellaneous/2908/When automating administrative actions for SQL Server, there are a number of ways to handle the workflow. Longtime SQL Server DBA Roy Carlson brings us a technique for using a text file as input to the standard SQL Server tools. http://www.sqlservercentral.com/articles/Miscellaneous/2801/2008/01/14http://www.sqlservercentral.com/articles/Miscellaneous/2801/The use of bitmasking is usually limited to decoding values in the system views, but it can be useful in other places when you want to save space. New author Lee Everest brings us an introduction to bitmasking and its use in SQL Server 2005. http://www.sqlservercentral.com/articles/Miscellaneous/2748/2007/12/05http://www.sqlservercentral.com/articles/Miscellaneous/2748/New author Jambu Krishnamurthy brings us a look at table variables and how they differ from temporary tables in SQL Server 2000. http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/2691/2006/11/21http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/2691/Testing is an important part of programming and it is no different with SQL Server development. Longtime author Grant Fritchey brings us a look at the new testing features available in Visual Studio 2005. http://www.sqlservercentral.com/articles/Miscellaneous/2689/2006/11/15http://www.sqlservercentral.com/articles/Miscellaneous/2689/The definitively "hands-on" guide to handling dates and times in SQL Serverhttp://www.sqlservercentral.com/redirect/articles/2661/2006/10/25http://www.sqlservercentral.com/redirect/articles/2661/SQL Server does a great job of handling concurrency & ensuring that users can make changes in multi-user systems without conflict. However there are times a strict calling order is needed. http://www.sqlservercentral.com/articles/Miscellaneous/2649/2006/10/17http://www.sqlservercentral.com/articles/Miscellaneous/2649/Not many people enjoy using Globally Unique Identifiers (GUIDs), partly because they are cumbersome to type and work with for humans. However they fill a need and can provide some interesting benefits. SQL Server expert Andy Warren takes us through what a GUID is and how you can use it easily in your code. http://www.sqlservercentral.com/articles/Miscellaneous/alookatguids/2497/2006/07/27http://www.sqlservercentral.com/articles/Miscellaneous/alookatguids/2497/Attaching and detaching databases is old hat these days right? Do you know how to reattach a database that has more than 16 files? Or do you know what happens if you try to reattach a database that had two log files but one is missing/deleted? And even if you know the answer to that - do you know how to fix it without restoring from backup? Maybe it's not ALL old hat just yet! http://www.sqlservercentral.com/articles/Administering/attachanddetachagain/656/2006/06/23http://www.sqlservercentral.com/articles/Administering/attachanddetachagain/656/Commenting seems to be the bane of every programmer, database or otherwise. Sachin Dedhiya brings us a look at brings some standards to how you should comment your code in a SQL Server database. http://www.sqlservercentral.com/articles/Miscellaneous/databasecommentingguideline/2437/2006/06/13http://www.sqlservercentral.com/articles/Miscellaneous/databasecommentingguideline/2437/Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about? http://www.sqlservercentral.com/articles/Miscellaneous/introductiontotheadoconnectionobject/510/2006/05/26http://www.sqlservercentral.com/articles/Miscellaneous/introductiontotheadoconnectionobject/510/For many of us, working with the identity property allows us to easily generate a sequential series of numbers. But what if you need to generate a sequence according to some pattern, like one that includes the year? New author Asif Sayed brings us a technique and the code for generating a patterned sequence. http://www.sqlservercentral.com/articles/Miscellaneous/generatingasequentialpattern/2390/2006/05/17http://www.sqlservercentral.com/articles/Miscellaneous/generatingasequentialpattern/2390/A SQL Server DBA often needs to perform ad hoc operations on data in their databases. The tasks can typically be handled with simple T-SQL statements, but other times a more complex operation is called for – and having to manually enter all the T-SQL code necessary for such an operation is not appealing! It can be difficult to perfect the syntax, and tedious to list column names once, twice or even three times. Fortunately, useful template code can be easily generated instead of being entered by hand.http://www.sqlservercentral.com/redirect/articles/2300/2006/02/27http://www.sqlservercentral.com/redirect/articles/2300/Robert is our expert on dynamic sql. This week he offers some good hints for planning the contruction of a proc that will use dynamic sql. He also adds some suggestions on how to format the code so that when you return to it later, you can figure out what you were doing! http://www.sqlservercentral.com/articles/Miscellaneous/howtobuilddynamicstoredprocedures/968/2005/12/16http://www.sqlservercentral.com/articles/Miscellaneous/howtobuilddynamicstoredprocedures/968/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/