SQL Server

SQL Server Disk Partition Alignment

The default alignment of 31.5Kb on Windows Server 2003 can lead to enormous I/O performance problems with SQL Server (see… Read More

December 18, 2016 9:45 am 09:45

SAN Performance Tuning with SQLIO

SAN Performance Tuning with SQLIO The SQLIO Disk Subsystem Benchmark Tool was a free utility from Microsoft that measures storage… Read More

January 23, 2015 9:34 am 09:34

Reverse SQL Server Log Shipping Roles

So you've configured log shipping. That's only half of the puzzle solved. This article will show you how to reverse… Read More

December 2, 2012 1:36 pm 13:36

Change SQL Server Name

If you've changed your Operating System hostname, you should reflect that change in SQL Server by updating the name in… Read More

November 8, 2012 9:08 am 09:08

MSSQL Check Index Fragmentation

Query to find the fragmentation status of all indexes on a single database. Line 11 you need to insert your… Read More

November 8, 2012 9:02 am 09:02