You can change it in Windows. That maps the drives to a particlar LUN/storage path.

Or if you do the detach, attach, as long as you don't have code referencing drives,...

You could check out this book as well http://www.sqlservercentral.com/articles/books/67441

Hard to tell there. I think it's entirely possible that some code just flaked, or something hung and a reboot fixed it. Typically if you didn't have a large transaction...

I don't think it's a good deal. I heard that Pujols will get an A-Rod type deal and St Louis doesn't want to pay it. Philly could, if they chose...

So a disk failure is a Windows/hardware event, not a SQL Server one. Can you see and access the disk from Windows? Once that is working, SQL Server should pick...

You're not changing servers, right? I mean keeping the Windows hosts (names, IPs, etc.) the same? Just changing storage? I think your original plan makes sense if you are doing...

#7 up front. I was an all-star catcher that year. A few years later my eyes went bad and I moved to 1B, outfield, and started my decline to mediocre,...

Memories....

Registered last night for the new season, getting excited though no practices yet, and I'll miss opening day with a long trip to the UK.

BTW, anyone think Pujols for Howard...

Yep, #7, many moons ago.

You hope management has thought things through, but often I've found they haven't. It's only the people that have been through things that tend to have plans in place, or...

Congrats, Lynn! Well earned and thanks for the support.

Meaning that we're not discriminating?

Actually we're not. We try to get a wide variety of opinions and styles. Happy to get some people writing from the Standard after a few...

baseball.

Registered for the new team and got a picture in the mail from Mom

Short summary of how I used to do this

- Create small db on every instance to hold data.

- write scripts to gather metrics, separate table for each metric. Use a...

I'm with Alvin. Wary of overloads on dates. Especially with potential calendar issues across time zones. I prefer using the functions that explicitly call for the operation