Thank you to all for taking the time to reply, it is always good to get a second opinion. Not that we don't trust our vendors but IP addresses seem...

Thank you Jack and Seth, while not as pretty, I can make these work for what I need to do.

Microsoft: This isn't a unique thing to do, why don't you...

I thought it was a good article but haven't had a chance to set up an environment to work with yet. One more thing on my to do list...

Our VM...

Great to hear it is a simple as that. We are a pretty small operation and learning what to do (and unfortunately what not to do) as we go. I'll...

I guess it all goes back the appropriate answer to any SQL Server question is "It Depends". 😀

This is a data warehouse, so lots more reads than writes for me...

I was hoping that was the answer, thanks for the quick response!

Norman

Thank you for the answer, you are correct. I meant to ask about ALTER DATABASE. It has been one of those weeks...

I didn't know that if I take the DB...

Yeah, I've got several of these sized tables that I have to deal with. But the surprising thing was the lack of CPU and IO activity. Just seems like something...

Sorry, should have included that little bit - no, nothing is reporting being blocked that I can see. Generally nothing else running at the moment.

Generally these are created in 20...

What we are trying to do is consolidate a bunch of scattered department servers into one central SQL server. None of them have users that are company wide but contain...

Thanks for the pointer, an interesting program since it shows the first and last letters in the password but I don't see a way to get the entire password out....

And thank you as well Lowell,

Much less of a problem than I thought.

Norman

Thanks! I learned something new today!

Norman

Thank you Gail,

I normally wouldn't shrink a database but I get nasty-grams from the server admins about the disk being full. All I want to do is shrink it by...

Thank you Gail and MJ - I wish I would have known that.

Norman