Tag Archives: Performance

Foreign Keys Help Performance

Posted on May 2, 2011 by way0utwest

I have always put FKs into my database for data integrity purposes. I’ve worked on enough applications that didn’t have FKs, or any RI in place and it was always a nightmare when the application broke down or there were … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Foreign Keys Help Performance

Test Before Deciding

Posted on March 21, 2011 by way0utwest

Will a new index improve the overall performance of your database server? Will adding another index slow down your insert or update performance? Can adding another file to tempdb make things run quicker? The answer to all of those questions … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Test Before Deciding

Disk Partition Alignment–MCM Prep

Posted on January 21, 2011 by way0utwest

Does disk partition alignment matter to SQL Server? Without a doubt. When new disk partitions are created, there could be a reserved set of sectors that could differ across disks because of the way that the hardware interacts. In the … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Disk Partition Alignment–MCM Prep

Speed

Posted on December 6, 2010 by way0utwest

We are always improving our computer hardware. It used to be that our CPUs increased their clock speed regularly. Then we started to add additional cores. Along with large increases of memory and disk technology, there has been this quest … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Speed