I know this is old, but the links to the sql are broken.

I know this is old, but the links to the sql are broken.

I put up a blog post[/url] a while back on tempdb that had some of the info from Tara's script.

It may or may not be helpful to someone.

Have you considered backup and restore?

Generate the script one time, dynamic SQL maybe?

Are you wanting to create that many linked servers on one server or the same linked servers on each of the 90 machines?...

I would recommend starting here[/url] and following the 2 related articles.

It will work great with what you are talking about as well as a ton of other stuff.

This is the first I've seen of having one of the files set to autogrow. Where'd you come across that recommendation?

yea, multiple tempdb data files can help with contention.

Usually you start with the # of files = to the cpu count.

I've got that part, and there all in the same...

yea, the thing is that there's a ton of traffic on that iSCSI and that's why I'm leaning towards leaving them local.

I suggest that everyone read this ebook. Really motivated me.

See if this discussion will help you. I'm still trying to get it to work myself.

Ok, I agree on speed, compression, and encryption.

What about the portability of not deal with a third party file extension?

What about your backup and restore scripts working anywhere without extra...

you are very welcome Emiliano.

I need a bigger staff of technical editors. 🙂

I...