The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Given that the next version of SQL Server probably won't support a direct upgrade from SQL Server 2000, now is the time to upgrade to SQL Server 2008. We'll show you how.
By Itzik Ben-Gan
Learn how to use a T-SQL split function to handle arrays as inputs for SQL Server stored procedures.
By Michael Otey
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.
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 Orin Thomas
There’s a lot to know about upgrading from SQL Server 2000 to 2008. This article guides you through the process.
By Rodney Landrum
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.
SQL Server 2008 provides performance counters and trace events that you can use to track which deprecated features are being used in your environment.
By Eli Leiba
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 William Sheldon
Create T-SQL scripts to run on target systems for exporting table data to remote clients.
By Gary Zaika
If you have a large table with future dates in it, you can use the method described here to partition it.
advertisement