SELECT *
FROM Posts
WHERE Tags IN ('SQL Server Internals')

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 »

feb
9
2017

Estadísticas y Tipos de Datos, Qué Podría Salir Mal?

Una de las cosas más interesantes en SQL Server desde mi punto de vista son las estadísticas y cómo el optimizador las interpreta para producir planes de consulta óptimos. Pero hoy quiero escribir sobre algo…

Continue Reading »

nov
30
2016

In-Memory logging, much cooler than disk based

Last week we started exploring some of the cool features that the new In-Memory engine (code name Hekaton) has brought into…

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 »

sep
6
2016

Database design Matters, choosing the right data type

This is not the first time I write about best practices or how a good design can…

Continue Reading »

may
25
2016

TRUNCATE TABLE misconceptions

TRUNCATE TABLE in SQL Server is well known for what it does as feature, but how it actually works is easily misunderstood, and for long time, the same…

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 »