ricardo_chicas (9/13/2010)
Actually my concern is that we have several dbs and ost of users, so I really need to be careful with the use of temp db, I like the approach ofCreate table
create clustered index
Inserts
nonclustered
In general that would be the prefered order if you load a full set. It will get you most optimal indexes with regards to fragmentation.
Keep in mind loading in order of the clustering index will have advantages too with regards to space usage and IO.
However, tempdb is always a special case, so profound testing may be in order !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me