Personally, I'd suggest you'd be better off collecting this information from Performance Counters in the Performance Monitor utility rather than using the DMV. It doesn't capture OS level information, and...

Purchase a really large server...

Seriously though, you need to evaluate the amount of storage you'll require on a single box. You need to understand which databases can share drives and...

FNS (4/24/2009)

---

Interested to know views on this:

An SQL job will restore the database at a specified time (weekly). This db shouldn't be in use as it's test and will...

Ah, different world. I think you're right.

I use Team System Database Edition. You don't connect to the .mdf/.ldf files with that tool either. You connect to a database through a connection string, or you have a...

You're trying to open the file. You can't.

You need to provide a server and instance name as part of the connection string for Visual Studio. It's the same server name...

I'm sorry, I don't have my abstracts in a readily digestible format anywhere. Something else to do next time.

However, if you register as a speaker you can look at all...

"Here's a pile of something brown & smelly. Turn it into shiny gold for me... Now!"

Ah, well, that's where you'll need to back to the Waits & Queues article that Matt posted to see what's causing the slow down. From the description, it's either CPU...

You've got today and tomorrow to put an abstract together. The worst that'll happen is they say no. Go for it.

It could be two things causing the slow down, since your views are calling views, the resolution of all those database objects is going to slow things down, as you...

Since the code is unusable, I don't see the point of keeping it intact. Comment it out. That will leave it in place if you really must.

Yeah, a pretty standard solution for avoiding NULL values.

The thing is, the query window in SSMS is for manual entry, not automation. It's unlikely they'll automate it when MS is already providing sqlcmd.exe and PowerShell scripts (another option)....

Actually you can register on the last day of the conference if you want to. I don't know why you would, but it's possible.