Browse by Tags

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 ...