Tag Archives: sql server

SQL Server 2008 – CDC Retention

Posted on October 26, 2010 by way0utwest

I had done a little work with CDC last year, experimenting with the way that it handles changes in your database. Someone had asked me the question about the retention period since the default of 3 days was not sufficient … Continue reading →

Posted in Blog | Tagged , , | Comments Off on SQL Server 2008 – CDC Retention

SQL Slammer

Posted on October 23, 2010 by way0utwest

Seven years ago I was in the mountains of Colorado, taking advantage of the a school break to get away for a long weekend. There wasn’t good cell phone coverage up there, and I was surprised as we drove back … Continue reading →

Posted in Editorial | Tagged , | Comments Off on SQL Slammer

Plan for Capacity

Posted on October 21, 2010 by way0utwest

In many applications, it seems that performance often falls off a cliff at some point because no one is planning for capacity increases. Everyone talks about the potential load on the system when it’s first being built. However since we … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Plan for Capacity

Common SQL Server – Not Indexing FKs

Posted on October 20, 2010 by way0utwest

This series looks at Common SQL Server mistakes that I see many people making in SQL Server. Foreign Keys It’s way too often that I see people building databases without including declared referential integrity (DRI) in their databases. Even when … Continue reading →

Posted in Blog | Tagged , , , , , | Comments Off on Common SQL Server – Not Indexing FKs