Browse by Tags

Exploring backup read io performance
24 January 2010 14:12

I was recently exploring how to increase the backup read throughput on one of our SQL servers. Below are some interesting facts i found. I would say that one of the most important reminders that came from the exercise is, do not assume that 2 databases being backup up on the same server using an identical backup command means that the processes are identical... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, Tips, Performance, Database Engine, 2008, Backup

The overhead of a non-unique clustered index
20 October 2008 00:21

So, we all know that if we create a clustered index that is not unique that we will incur a 4 byte overhead right? Well not always because as usual, it depends..... When you create a non-unique clustered index SQL server must maintain uniqueness so it adds a hidden 4 byte column which is populated for each non-unique row (not every row) but what many people may... Read More...

by ACALVETT | 3 comment(s)

Filed under: SQL 2005, SQL 2000, Tips, Database Engine

Changing the Data Files Location after Installation
10 August 2008 10:28

The other day i wanted to change the "Data Files" location for a 2005 database engine installation and a 2005 Analysis Services installation which you can specify under the advanced options during installation. I quickly found out that there appears to be no documented ways to do this other than uninstall SQL Server and install again specifying a new... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, Tips, Analysis Services, Database Engine