Tag Archives: administration

Who Still Uses SP_ for Naming?

An interesting post recently from Chad Callihan on the reasons why someone shouldn’t use sp_ to prefix their stored procedures. This is advice that I’ve seen for years, but I haven’t run into this lately with many customers. It seems … Continue reading

Posted in Editorial | Tagged , | 6 Comments

Be Careful with Missing Index Requests

One of the things that has been interesting to watch over time is how the SQL Server platform has expanded the amount of information that we get back about the performance of the query optimizer and query processor. While it’s … Continue reading

Posted in Editorial | Tagged , | Comments Off on Be Careful with Missing Index Requests

Ten Database Commandments

I love the Notorious B.I.G. His music isn’t for everyone, but I enjoy it. This piece takes one of his songs (NSFW – Ten Crack Commandments) and applies the list to databases. Each item from the song is listed, along … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Ten Database Commandments

Running a Service

Many of us work for some organization and we’re responsible for managing a database or coding some application or some other data related position. Perhaps we ensure reports work for our users or move data around. In many cases, we … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Running a Service