Posted by: Charles Maitland | Thursday 2 February, 2006

Feel the power

I have just done a test on the main query for the data warehouse.
The query has 9 joins from 7 tables, 7 additional criteria in the where clause.
One of the tables has 7 million rows, another 15 million rows.
SQL Server 2005 crunched it in 16 Mins 15 Secs and returned 4.5 Million rows.
Not bad considering it was running on MY LAPTOP!
I cant wait to see it run on the server with Dual Xeons large RAM and Raid.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


%d bloggers like this: