December 2008
Here's a solution you can use when you need to disable XML validation yet have Service Broker continue processing when it encounters a poison message.
November 2008
MaintenanceSolution.sql lets you easily back up databases, check their integrity, and optimize indexes. This script is set up so that you can perform each task independently on the databases you specify.
November 2008
Here's a stored procedure that lets you quickly and easily produce customized reports showing the poorest-performing T-SQL statements that were run against your SQL Server 2008 and SQL Server 2005 databases.
November 2008
The SpaceUsedAnalyzer stored procedure provides detailed information on how much space is being used by tables and their indexes so that you can manage disk space more efficiently.
November 2008
Need to change the word "Bikes" to "Trucks" without modifying "SuperBikes" to "SuperTrucks" or perform another word-replacement operation? This user-defined function (UDF) will do the trick.
October 2008
You can use the TOP clause to limit the transaction size, but there's a trick to using it: You need to keep track of which rows have already been updated so that you don’t update them a second time. Here's how to keep track of the rows.
October 2008
Here's a T-SQL stored procedure that you can use to identify tables without indexes, indexes that aren't being used, and indexes that aren't being used efficiently.
October 2008
Use this password-cracking tool to check the complexity of the passwords being used for SQL Server database logins.
August 28, 2008
Although companies might want integer sequences in database applications to be gapless, gaps occur frequently. Here's a solution that you can use to eliminate existing and avoid new gaps.
August 2008
Here's a T-SQL stored procedure that finds and moves the clustered-indexes user tables you specify from old file groups to new file groups.
August 2008
Having to modify stored procedures when an object name changes can be tedious. Here's a T-SQL stored procedure that eliminates the tedium from this task.
August 2008
This T-SQL stored procedure searches all the databases on your server for the string you specify and returns a list of the objects that contain it.
July 2008
No temporary tables or table variables are needed to perform FOR XML PATH concatenation, so the resulting query is not only fast but also high performing.
June 2008
If you have a lot of data to import into or export out of a SQL Server table, here are some tips that can save you a lot of time and aggravation.
May 2008
Ensuring that databases are being backed up properly is an important but time-consuming task, especially for DBAs who manage multiple servers and databases. The sp_ShowBackups stored procedure makes this task quick and easy.
April 2008
If you have to perform a full index analysis, here are two T-SQL stored procedures you can use to get detailed information about the indexes in a single table or an entire database.
February 2008
It's not uncommon for MDX programmers to create an elegant calculated member, only to discover that it's so slow that it can't be used in queries against a full data set. Learn why performance problems can occur and ways to work around those problems.
February 2008
Using SQL Server Management Studio (SSMS) to document job schedules involves a lot of mouse-clicking and cutting and pasting. You can avoid all that hassle by using the sp_ShowJobSchedules stored procedure.
January 2008
This user-defined function is flexible and easy to maintain because it uses a matrix and simple math to locate the date you need.
December 2007
LoadTraceFileToTable loads the data from a trace file into a trace table so that you can easily sort and analyze that data.
Add these Headlines to your Website
