It depends on how heavily you're hitting tempdb, and how much IO you're using. I've seen plenty of servers that weren't using tempdb heavily, or were heavy read-weighted servers. Moving...

I did reply that his comments were not very professional and that I disagreed with the way he was approaching the job.

Not that it matters, but others need not lower...

The difference is that when I did a lot of this, we didn't have try..catch logic.

It may or may not be different with try..catch. Haven't used it enough in breakage...

I've used lots of cursors for small jobs like this, things where I need to run something as a one-off. I've never had issues, but they've mostly been small...

That thing that seems strange is that you are checking the property of if this is a user table. Is the type commented out? Hard to tell from the formatting....

If you're not moving to faster drives, I'm not sure you get better performance from tempdb, it's more likely that the overall I/O on the server instance is better.

What you...

I tend to agree with Jeff, but I don't see a huge problem with the cursor. The thing I don't like is putting this in a job step.

Instead I'd create...

Yes, it has SSRS.

The thing you want to be careful of with going 2008 is that some things you might work on, or try, will not work on 2005. Most...

It's not a bad idea. What I think we would like to move to is more of a tag based system, like at ask.sqlservercentral.com.

I did some work for a dentist, he was OK other than not wanting to pay. Worked for a builder as well. Not fun.

Wow, that's something.

Let us know if you find anything. This has been very interesting.

If you are around average people, or those that aren't smarter than you in the area in which you work, it's tedious. It's moving along, and it's easy to get...

OpenID has providers from a number of sources. I use my Google account, and as long as I'm signed in on a browser, that works. Not sure if any of...

Your post was fine. I added this reply to a couple threads since a few comments were approaching the personal line. I just wanted to remind people to keep things...

Check the default trace. That should tell you who sent it in