Browse by Tags

• nonclustered index
• parameter sniffing
• statistics
• temp tables

• Geek City: String Statistics

  If you’ve ever run DBCC SHOW_STATISTICS, you know you get 3 sections of information back. The first section is basic information about the last time the statistics were updated, the number of rows, the number of steps, etc. The second section is density Read More... Posted Wednesday, February 13, 2008 3:18 PM by Kalen Delaney | 4 Comments Filed under: nonclustered index, showplan, statistics

• Did You Know? Estimated vs Actual Plans

  In my previous post, I mentioned that it is important to understand the difference between estimated and actual query plans, so I decided to go into a few more details regarding the differences. Optimization takes place before execution, so in one sense, Read More... Posted Monday, July 30, 2007 12:41 PM by Kalen Delaney | 5 Comments Filed under: parameter sniffing, temp tables, showplan