question

Dave 3 avatar image
Dave 3 asked

Query with inmemory sort

Recently i came across a very good performance tuning webcast in sqlworkshops.com.. The presenter showed how to do inmemory sort for very big results from a query without spilling them to tempdb in SQL 2008.

Does anyone know how to achieve the same in SQL 2005. Any insights will be appreciated.

performance
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Do you have a link to show how this is done? I've never heard of a mechanism that will prevent the tempdb from being used for a sort operation within an execution plan.
1 Like 1 ·
Jonathan Kehayias avatar image Jonathan Kehayias commented ·
Grant, there are 3 videos up on http://www.sqlworkshops.com that you can grab. http://sqlworkshops.box.net/shared/static/nykoavktz7.wmv http://sqlworkshops.box.net/shared/static/1vtqe1r2c3.wmv http://sqlworkshops.box.net/shared/static/b2r2a161qq.wmv Looking forward to watching them end to end myself.
0 Likes 0 ·

1 Answer

·
Fatherjack avatar image
Fatherjack answered

Dave, What happens when you try it on SQL 2005?

If I remember rightly I saw Ramesh Meyyappan demo this at a workshop at SQLBits in November (my review here) and dont remember anything that indicated it would only work on 2008.

Jonathan

2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Dave 3 avatar image Dave 3 commented ·
Jonathan, i did try it in SQL 2005 and it didn't work.. If fact he gave that as a assignment in his webcast.
0 Likes 0 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
awww, crap. That was going on my list of things for next year. Well I wont need to review it now as we are currently all 2005 ...
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.