Tag Archives: indexing

The Clustered Index is not the Primary Key

Posted on May 24, 2016 by way0utwest

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

Rebuilding a Heap–Don’t Do It

Posted on January 13, 2016 by way0utwest

I saw someone mention recently that you can run a REBUILD on a heap table. I hadn’t realized that, but when I looked in BOL, I saw that indeed you can run this on a heap. That’s interesting, in that … Continue reading →

Posted in Blog | Tagged , , | 3 Comments

Reframing to Overcome Filtered Index Limitations

Posted on May 7, 2015 by way0utwest

I’m continuing on with the Blogger’s challenge in this post. Turning the Problem Around In the last post, I wrote about limitations in filtered indexes. I proposed that my table had lots of data with NULL or blank spaces in … Continue reading →

Posted in Blog | Tagged , , , | 12 Comments

April Blogger Challenge 4–Filtered Index Limitations

Posted on April 30, 2015 by way0utwest

The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to motivate and cheer people on. Filtered Index Limits I ran across a limitation recently with filtered indexes and was surprised. … Continue reading →

Posted in Blog | Tagged , , , , | 1 Comment