Thanks Jeff .. by default, will all sorting be done in tempdb during Index creation?
It took you longer to post the question than it would for you to look it up. You have to learn to look stuff like this up. Lookup CREATE INDEX and then search for "tempdb" in that documenation.
Then try it out and let us know. 😉 I know the answer but want to see if you'll come to the right conclusion.
I'm not saying that to be snarky or mean. You need to learn to look stuff up instead of relying on the kindness of strangers. It will make you much more valuable to your company. Where there's perceived value, there's normally some $$$ in the form of an annual increase. Higher performances get a bigger chunk of the bonus pie.
As a bit of a sidebar, I don't want big tables to sort in tempdb. I want to save tempdb for other stuff that is running at the same time. Others will have a different opinion/recommendation but mine is, leave tempdb alone for stuff like this.