We are talking about this, but we really want the forum software vendor to do this so that we can upgrade without losing work.

What are you running sqlsdiag for? It gathers information from the run, and if you run it multiple times without rebooting/restarting, I suppose they could be larger files, but I...

You need a driver from the source system. Is this stuff running on the mainframe?

Also, please post in the appropriate forum. I have moved this to 2005 development.

It could work, but IMHO, it's a bad move. At least to move everything. You could move some stuff, but I'd like someone nearby I could call in a pinch....

jgrubb,

nice synopsis and I think you've hit it. It works well in places, just be aware of what you're getting (and missing).

There are definitely people posting interview or homework questions. Please feel free to call them on it if you don't want to answer.

And participate where you can. Don't feel bad...

Sorry for the late note.

Seeing the paper result, but not holding it is interesting. And it's a good compromise, perhaps the best we'll ever get.

I read in one place that...

Gail has it correct. It will use more space, because it rebuilds things, but MDF files will grow only if you run out of space inside the current MDF files...

I'd agree with Michael. Go through the maintenance plan wizard for a start.

It comes and goes in waves. Plenty of new people being thrown into SQL Server every day, struggling to learn.

Most people aren't like those of you that answer questions. They're...

I doubt I'm more biased than anyone else that doesn't work for a vendor of a platform, or doesn't belive in Open Source.

I've made my living off SQL Server, but...

I've tried two things. One, give each developer their own schema on a central server and then "change object owner" when things move to the point where we want them...

Marios,

What are you trying to do? They usually perform separate actions, but if you are looking to just update another server, I might recommend looking at Service Broker.

Typically there's a utility with the hardware vendor that can check this, but it's an OS level task, not something you can see from SQL.

As mentioned, contact your Windows admin.

Not likely to hit Phoenix, but Vegas would work. Orlando, Dallas are other locations they've used.