SELECT *
FROM Posts
WHERE Tags IN ('Clustered Index')

Mar
29
2017

Spring cleanup, LOB considerations

So spring time is here and probably you feel like cleaning up your databases, and that’s good. In previous posts…

Continue Reading »

Nov
3
2016

Database Design Matters, Real World Scenario

Disclaimer: This is how I solved a particular problem after analyzing and understanding my data….

Continue Reading »

Oct
19
2016

Successful Anti-Patterns, Storage Requirements

One of the things you realize with experience is…

Continue Reading »

Sep
21
2016

Database Design Matters, choosing the Clustering Key

There has been a permanent debate about which is the right clustering key for our tables since the…

Continue Reading »

May
18
2016

Index fun, disabling the Clustered Index

Following a conversation with my junior DBA, I decided to show you what happens when we disable indexes and in particular when we disable the clustered index for a…

Continue Reading »

May
10
2016

Successful Anti-Patterns, Key Lookup VS RID Lookup

When it comes to technical subjects like databases, we must always look for proven solutions and best practices, which usually take us from A to B in the most efficient way. Usually. But what happens…

Continue Reading »

Feb
29
2016

Clustered index row order

One of the basic (and well used during interviews) questions about SQL Server internals is how you call a table without a clustered index, and that in SQL Server is called a HEAP….

Continue Reading »