By Itzik Ben-Gan, 12/23/2008
Learn how to use a T-SQL split function to handle arrays as inputs for SQL Server stored procedures.
By Michael Otey, 12/23/2008
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 ...
By Itzik Ben-Gan, 12/23/2008
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, 12/23/2008
There’s a lot to know about upgrading from SQL Server 2000 to 2008. This article guides you through the process.
By William Sheldon, 12/23/2008
Create T-SQL scripts to run on target systems for exporting table data to remote clients.
By Eli Leiba, 12/23/2008
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 ...
By Itzik Ben-Gan, 12/23/2008
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 Rodney Landrum, 12/23/2008
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 ...
By Gary Zaika, 10/28/2008
If you have a large table with future dates in it, you can use the method described here to partition it.