Very Good Tips on S2k8 64-bit Query Optimization

I was reading this tip on MS SQL Tips by Matteo Lorini and I wanted to pass along the link to it. Matteo has called out a very interesting catch in the 64-bit version of SQL Server 2008 query optimizer whereby he found that SQL Server needed to be fooled into thinking that a row size was large enough to allocate more memory for the query. Otherwise, SQL Server was going to have to perform I/O with R/W to Temp DB. Nice catch!

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s