Tag Archives: indexing

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 ,

The Clustered Index is not the Primary Key

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