SQL Server Magazine January 2009
[Focus]
There’s a lot to know about upgrading from SQL Server 2000 to 2008. This article guides you through the process.
By Orin Thomas
[Features]
Use this Gantt-chart–style overlay report, based on SQL Server Reporting Services 2008 and an enhancement to the Data Repository solution, to find the best times to run SQL Server Agent jobs.
By Rodney Landrum
Find out which features are missing or are deprecated in SQL Server 2008, as well as which features SQL Server won’t support in a future version.
By Itzik Ben-Gan
If you have a large table with future dates in it, you can use the method described here to partition it.
By Gary Zaika
[Reader to Reader]
You can change many configuration options in SQL Server 2005 and SQL Server 2000 simultaneously by using a.config file and a T-SQL stored procedure that automates the use of the sp_configure system stored procedure.
By Eli Leiba
[T-SQL Black Belt]
Learn how to use a T-SQL split function to handle arrays as inputs for SQL Server stored procedures.
By Itzik Ben-Gan
[SELECT TOP(X)]
Your SQL Server build versions can affect whether you should perform an upgrade or a new installation—learn how to find your SQL Server version number and whether an upgrade is in your future.
By Michael Otey
[Review]
Create T-SQL scripts to run on target systems for exporting table data to remote clients.
By William Sheldon
|
