This is a quick update on the T-SQL exercise I posted a few days ago. The goal was to write a simple T-SQL script to generate and load 4,000,000 rows into a table so that the following query would produce the worst performance, i.e. take longest time to finish:   DBCC DROPCLEANBUFFERS go SELECT COUNT(*) FROM dbo.test;   The ...

Here is a T-SQL scripting exercise in case you have a few minutes to spare or are bored with whatever else you are doing.    Objective The task is to write a simple T-SQL script to generate and load 4,000,000 rows into a test table. The objective is to make the following simple test query to have the worst performance in terms of ...