Tag Archives: indexing

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

Rebuilding a Heap–Don’t Do It

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

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

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

The DBA Team #1–Code and Slides

Our first DBA Team event, in Richmond, VA just before SQL Saturday #187 went well. Overall I think our experiment was a success and we’re already talking about where and when we might do this again. In the meantime, we … Continue reading

Posted in Blog | Tagged , , , , , , | 2 Comments

Dropping Indexes

While working on some demos recently, I needed to drop an index for a test. I executed this generic statement for an index I’d just created. 1: DROP INDEX ix_IndexName Needless to say I was surprised when I got this … Continue reading

Posted in Blog | Tagged , , , | 3 Comments

Review Your Indexing

In the latest versions of SQL Server, there are some amazing new features. Many of them allow us to expand the capabilities of SQL Server, but some are added to allow us to dive more deeply into how the system … Continue reading

Posted in Editorial | Tagged ,

Trace Flag 2371 and Statistics

One of the issues that I see published often on forums like SQLServerCentral is the advice to update statistics on your tables if you have strange performance issues, or sudden changes in performance. Statistics are important for the query optimizer, … Continue reading

Posted in Blog | Tagged , , | 4 Comments

Common SQL Server – Not Indexing FKs

This series looks at Common SQL Server mistakes that I see many people making in SQL Server. Foreign Keys It’s way too often that I see people building databases without including declared referential integrity (DRI) in their databases. Even when … Continue reading

Posted in Blog | Tagged , , , , ,