Welcome to MSDN Blogs Sign in | Join | Help

July 2008 - Posts

SQL Server Load Test Utility Released

A utility to generate unit tests for Visual Studio Team Suite has been posted to Codeplex. This tool takes a SQL Profiler trace file and generates a unit test that replays the same sequence of database calls found in the trace file. The unit test is designed Read More...
Posted Tuesday, July 22, 2008 1:02 PM by Tom Mills | 1 Comments

Finding Fragmented Indexes in a Database Running in SQL Server 2000 Compatibility Mode on 2005

The Index Physical Statistics report in SQL Management Studio is an easy way to identify fragmented indexes. But the report won't run against a database set to 8.0 (SQL Server 2000) compatibility mode. Here's a script that will generate a list of fragmented Read More...
Posted Wednesday, July 02, 2008 2:06 PM by Tom Mills | 2 Comments
 
Page view tracker