Tag Archives: sql server

Downtime

Posted on October 11, 2010 by way0utwest

How does someone handle downtime in a small business? Steve Jones has some thoughts today based on a question sent in recently. Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Downtime

Are there that many GUIDs?

Posted on October 1, 2010 by way0utwest

Steve Jones talks about a recent survey that showed more people use GUIDs as primary keys than identity values. Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Are there that many GUIDs?

Common SQL Server Mistakes – Indexing Every Column

Posted on September 29, 2010 by way0utwest

If one index helps speed up queries, than more indexes should help more, right? They do, but they also come at a price. Both in performance during data modifications (insert/update/delete), and in terms of space since each index must be … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Common SQL Server Mistakes – Indexing Every Column

Community Direction

Posted on September 22, 2010 by way0utwest

When Microsoft implemented Connect, I thought it was a great idea. It was a way for real users to submit bugs, and others to see those bugs, voting on them if they thought they were important. It would help Microsoft … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Community Direction