SELECT *
FROM Posts
WHERE Tags IN ('Storage Engine')

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 »

abr
26
2017

Anti-patrones exitosos, utilizando tipos de datos obsoletos

De vez en cuando, es bueno recordarle a…

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 »

mar
2
2017

Analizando sistemas de almacenamiento con Diskspd.exe

La semana pasada estuve probando un nuevo…

Continue Reading »

nov
23
2016

In-Memory NonClustered Indexes, much cooler than disk based

Last week Microsoft has done it. The release of SQL Server 2016 SP1 is a game changer, most of the desired but sometimes prohibitive features from Enterprise Edition are now…

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
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 »

abr
26
2016

Shrinking large half-empty MDF

Once again I’ve found my inspiration browsing linkedin SQL Server groups. Love it! First I have to say I’m a big fan of DBCC SHRINK, I use it all the time… NO, that was a bad…

Continue Reading »