Saltar al contenido
SQLDoubleG
Menú
  • Inicio
  • Articulos
  • Trucos SQL-G
  • Idioma: Español
    • English English
    • Español Español
Menú

Etiqueta: Statistics

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

Posted on 09 de febrero de 2017

One of the most interesting things in SQL Server are Statistics. Today I want to write about the creation and update. Una de las cosas más interesantes en SQL Server desde mi punto…

Multi-column statistics are back in SQL Server 2016

Posted on 30 de septiembre de 2016

The new cardinality estimator in SQL Server 2014 brought new and improved query performance but as always there are caveats. Let’s check a specific case to see the different behaviors for the…

Update Statistics Misconception

Posted on 22 de junio de 2016

Having statistics up to date is important to get good query plans, but sometimes how to get it might be misunderstood On the 15th of June I made my first presentation at my…

Fast with values slow with variables

Posted on 03 de marzo de 2016

There is a big debate why the same query can run fast with hard coded values and slow when using variables, come see there is a reasonable explanation for all this mess. The…

  • About this blog
  • Articles
  • Development
  • Free Training
  • Security
  • SQL Server 2016
  • SQL-G Hacks
  • T-SQL Tuesday

Latest Posts

  • T-SQL Tuesday #158, Implementando Malas Practicas
  • T-SQL Tuesday #155 –The Dynamic Code Invitation
  • FillFactor, lo que Nadie te ha Contado
  • Cómo comparar el esquema de miles de bases de datos
  • Cómo Actualizar Estadísticas en SQL Server de la Manera Correcta
©2023 SQLDoubleG | Diseño: Tema de WordPress Newspaperly