October 22, 2009 at 3:28 am
Hi,
I have a user database running in SQLEXPRESS 2005 . This database could have different collation other than the server based on the installation. So The collation of Temp DB could be different from the User DB .
My query is will it be a good idea to use SORT_IN_TEMPDB option for Index Creation and/or REBUILD. If not what kind of problem can be created ..
Thanks in Advance
October 22, 2009 at 5:14 am
Bhaskar Basak (10/22/2009)
Hi,I have a user database running in SQLEXPRESS 2005 . This database could have different collation other than the server based on the installation. So The collation of Temp DB could be different from the User DB .
My query is will it be a good idea to use SORT_IN_TEMPDB option for Index Creation and/or REBUILD. If not what kind of problem can be created ..
Thanks in Advance
I am not sure if you would encounter any issue or not, the thing to remember regarding sort_in_tempdb, is it gives a performance gain, at the expense of more disk storage used.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 22, 2009 at 5:23 am
Thanks for your suggestion . I know I can get performance enhancement if the tempdb is on a seperate physical hard disc.
My main concern is what impact could hsve (if any) on my Index Sorting because of difference of collation
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply