SQL Server Magazine June 2009
[Features]
Avoid blocking and table locking by using this job to rebuild indexes online.
By Brian Smyk
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 Michael Otey
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 Greg Ritchie , et al.
[Reader to Reader]
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 procedure you can use if you don't.
By Chandra Sekhar Pathivada
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 objects before they cause problems.
By Jameel Ahmed
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 that does all the work for you.
By Shaunt Khaldtiance
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 Bill Lescher
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 Kristen Cheyney
[T-SQL Black Belt]
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 as when dealing with very large partitions.
By Itzik Ben-Gan
[SELECT TOP(X)]
Put these SSMS keyboard shortcuts by your computer and quickly connect to, navigate through, and manage in SSMS.
By Michael Otey
[Buyer's Guide]
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 look for.
By Jeff James
|
