THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
T-SQL Exercise: Simplest data-loading script to produce worst query performance – May 29th Update
This is another follow-up on the T-SQL exercise. So the test query below is rather simple: DBCC DROPCLEANBUFFERS go SELECT COUNT(*) FROM dbo.test; But beneath its simple appearance, many factors are at play and interact in a complex way to influence the query performance. In other words, trying to predict its ...
May 29, 2009
Brought to you by