Daily Archives: October 2, 2024

Enabling an Index: #SQLNewBlogger

I don’t do a lot of work with disabled index, but I learned how to re-enable one today, which was a surprise to me. This short post covers how this works. The Scenario Imagine that you have an index on … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Enabling an Index: #SQLNewBlogger

Cleaning Up Your Database

How many of you have objects in your database that aren’t being used? What about something in a schema with a _old in the name? Or _2 or _3 or _delete? There is a lot of old, deprecated stuff I … Continue reading

Posted in Editorial | Tagged | 2 Comments