Tag Archives: administration

DBCC CLONEDATABASE is Semi-Discontinued

Posted on June 3, 2024 by way0utwest

I saw a tweet that DBCC CLONEDATABASE was being discontinued for production databases, which both scared me and didn’t make sense. I’ve used this a few times for a quick copy of a database and like how it works. Discontinuing … Continue reading →

Posted in Editorial | Tagged | 2 Comments

Who Still Uses SP_ for Naming?

Posted on December 13, 2023 by way0utwest

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

Posted on December 4, 2023 by way0utwest

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

Posted on November 20, 2023 by way0utwest

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