Browse by Tags

• Decoding STATS_STREAM

  Data distribution statistics is one of the foundations of the cost-based query optimizer in all modern database engines including SQL Server. From SQL Server 2005 on, most of the information displayed by DBCC SHOW_STATISTICS is kept in a binary field Read More... Posted Saturday, May 05, 2012 7:16 AM by jchang | 6 Comments Filed under: Statistics

• Statistics Blunders

  One of the major blunders in SQL Server 2000 is in the calculation of data distribution statistics. In theory, it should be possible to take just a small true random sample to get a reasonable estimate of the true distribution. Because of the page organization Read More... Posted Friday, November 14, 2008 5:21 PM by jchang | 0 Comments Filed under: Statistics