Monthly Archives: October 2010

SQL Saturday Advice – Extra Food

Posted on October 21, 2010 by way0utwest

No matter whether you provide the food or have people pay for it, it seems that at every SQL Saturday I’ve attended, there is extra food left over. Sometimes it’s a very significant quantity. At one of the events I … Continue reading →

Posted in Blog | Tagged , | Comments Off on SQL Saturday Advice – Extra Food

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

Boulder SQL Server User’s Group – Common SQL Server Mistakes

Posted on October 20, 2010 by way0utwest

The first iteration of my presentation on Common SQL Server Mistakes, based on the various things I’ve seen in the forums over the years as well as written about on this blog, was last night. It went fairly well, though … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Boulder SQL Server User’s Group – Common SQL Server Mistakes

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