Tag Archives: indexing

Mastering Index Tuning–Day 3

Posted on July 3, 2018 by

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

Posted on July 2, 2018 by

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

Posted on March 21, 2018 by

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 ,

The Clustered Index is not the Primary Key

Posted on May 24, 2016 by

I was reading through a list of links for Database Weekly and ran across this script from Pinal Dave, looking for tables where the clustered index isn’t the PK. It struck me that this is one of those facts I … Continue reading →

Posted in Editorial | Tagged , | 1 Comment