Be sure you have indexes on the join columns as well.

Good links above and you'll certainly have some downtime when you do this, so plan for that.

I'd be sure you tackle things in stages. Personally I'd rename the server first...

Bert,

Please don't keep your opinions to yourself. I appreciate the critique. I just felt the need to defend myself a little.

We've had some posts pulled back over the years, but...

There are scripts here that will help if you really need this, but if you could answer some of Carl's first questions, we might be able to help you with...

My apologies then. The owner deleted his script, and since it was submitted anonymously, I cannot contact him or her.

For all I know it was you that deleted it...

Also this:

http://www.sqlservercentral.com/columnists/sjones/atemporarymove.asp

This is correct, but the log data is not retained, so it's a question of wording.

The log still exists in simple code, transactions are logged and once they commit, they...

Interesting discussion, but I hope people don't lose sight that it's a global issue, not a US/India one. Today lots of outsourcing is to India, but tomorrow it might be...

You are welcome and thanks.

FYI, I moved this to another forum.

Bert,

I'd disagree immensely with your post. No scripts have been withdrawn. Someone asked a question and it was answered.

The conference is in Denver this September.

If you click the reg link, you should go here and get a PDF: http://www.sqlpass.org/client_files/content/RegForm2007_FINAL.pdf

You need to manually fax or email this back for...

David, good for you. Have to say I like my media. Not too much stuff I watch, but sports, a few shows a week and some movies here and there...

Green Lantern, good to see you back and nice response. My wife and I lucked into a great walkin closet in our house. It's almost 10' x 14', but seems...

I moved the post

Red Gate doesn't take copyright for submisions (articles or scripts). We have agreements listed here that you agree to in...

My son was telling me about an XBOX game this week, so I guess I got influenced . Glad you liked it.