Sorry I didn't back sooner. Gail has already suggested the two things I would have, snapshot isolation and tuning the query & indexes. I'm pretty sure this is the answer....

I don't believe there's a way to hint table access. You can supply hints to the queries that access this database, but if you have ad hoc queries or client...

From the upgrades I've done, follow Gail's advice. The Upgrade Advisor will identify all the coding issues on the database side of the upgrade.

However, it's possible to have written a...

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.