Tag Archives: indexing

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

Mastering Index Tuning–Day 3

This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses in the past, but I wrote notes and wanted to revisit the way things went. This post looks at the … Continue reading

Posted in Blog | Tagged , , , , , | 6 Comments

Mastering Index Tuning–Day 2

This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses in the past, but I wrote notes and wanted to revisit the way things went. This post looks at the … Continue reading

Posted in Blog | Tagged , , , , , | 3 Comments

Interviews: Covering index

Performance seems to be a part of every DBAs job. It should be a part of every developer’s job, but I understand the focus to build software is different and many developers aren’t sure how much a feature or option … Continue reading

Posted in Editorial | Tagged , | Comments Off on Interviews: Covering index