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

nov
15
2021

FillFactor, lo que Nadie te ha Contado

I love SQL Server internals, I do and I just said it. Why? because thanks to all the tools, documentation and community members that share their knowledge, folks like me can understand how a super complex piece of software like…

Continue Reading »

mar
29
2017

Limpieza de primavera, consideraciones con datos LOB

La primavera ya está aquí y probablemente te entren ganas de hacer una limpia en…

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 »