Browse by Tags

Vital Statistics – free webcast now available
02 February 10 10:53 AM | Christian | with no comments

Another one of my sessions from SQLBits V, this time on SQL Server Statistics. You can it from the SQLBits website: http://tinyurl.com/yb2t2v5 The presentation was based on information that you’ll also find in my latest book, Professional SQL Server 2008...

Filed under: SQL Server 2005, SQL Server 2008, SQL Server Optimizer, SQLBits, Internals, Troubleshooting

What's the "cost"?
14 October 07 06:15 PM | Christian | 1 comment(s)

SQL Server uses a cost-based based optimizer which means that it will assign a "cost" to each execution plan and then choose the plan with the lowest cost. You can see evidence of this when you look inside an execution plan and see things like "CPU cost...

Filed under: SQL Server Optimizer