By Brian Smyk, 05/22/2009
Avoid blocking and table locking by using this job to rebuild indexes online.
By Fred Schuff, 05/21/2009
Tracking changes when you have several copies of a database can be a huge chore. These step-by-step instructions will let you produce a report that will find differences for you.
By Itzik Ben-Gan, 05/19/2009
Although set-based solutions to running aggregations have many advantages over cursor-based solutions, cursor-based solutions can provide better performance in certain cases, such ...
By Chandra Sekhar Pathivada, 05/18/2009
Deleting all the records in a database can be tricky when it includes tables with foreign keys. Here's a script you can use if you have ALTER TABLE permission and a stored ...
By Jameel Ahmed, 05/15/2009
Stored procedures, user-defined functions, views, and triggers can fail to execute when the objects they reference have been changed. Here's a tool you can use to detect broken ...
By Kristen Cheyney, 05/14/2009
Using a looping algorithm to determine the average number of days between orders can be painfully slow code to write and run. A better approach is to use the ROW_NUMBER function.
By Shaunt Khaldtiance, 05/12/2009
Storing SQL Server Integration Services (SSIS) packages under a well-defined folder structure in msdb is advantageous, but getting them there can be a hassle. Here's a solution ...
By Bill Lescher, 05/11/2009
After discovering a useful T-SQL stored procedure, a reader and his coworkers adapt it so it can perform more types of searches and more refined searches when needed.
By Michael Otey, 05/05/2009
What you need to know to set up your system to use SQL Server 2008’s T-SQL debugger.
By Michael Otey, 05/05/2009
SQL Server 2008’s IntelliSense, debugging, and code outlining features take some of the hassle out of writing T-SQL scripts and stored procedures.
By Jeff James, 04/15/2009
Tips from SQL Server backup and recovery experts can help you decide when to upgrade from SQL Server's native backup capability to a third-party solution, and what features to ...
By Michael Otey, 04/08/2009
Put these SSMS keyboard shortcuts by your computer and quickly connect to, navigate through, and manage in SSMS.