SELECT *
FROM Posts
WHERE Tags IN ('Statistics')

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 »

sep
30
2016

Multi-column statistics are back in SQL Server 2016

Don’t get me wrong, they’ve always been there, but somehow someone forgot about them and weren’t used. Since last…

Continue Reading »

jun
22
2016

Update Statistics Misconception

On the 15th of June I made my first presentation at my local user group, and I have to say that was a nice experience. The presentation is about SQL Server statistics and at certain…

Continue Reading »

mar
3
2016

Fast with values slow with variables

The other day I saw a thread on linkedin groups that was titled ‘Using Parameters in a Query is Killing Performance’, where the author…

Continue Reading »