It's a little more complex than that. You also have to take into account the logical, or business, identifier for each row. This is sometimes referred to as the natural...

And, in the event of failover, async means no guarantee of intact data.

I'd take a look at extended events. You can just capture the events that exceed a certain value for run time and then have them forwarded to just about anything...

Glad to hear it was narrowed down. It sure didn't sound like a physical problem. Good luck on the fix.

Glad to hear it's proving useful. Let me know if you have questions.

One of the first, and most important resources, you've already found. SQL Server Central is one of the best places to get more learning. Not only from the forums like...

With no information, I'm with Lynn. It's impossible to say what you need to do to improve performance.

But, whatever other forum you were on is partly correct. A view, a...

In terms of a "backup" as defined by SQL Server backups, no.

But, as has already been pointed out, there are a number of mechanisms for scripting out the procedures. Might...

If it's waiting on the log, you need to look to contention within your I/O system. Can you separate your log and data onto different disks and disk controllers? Can...

Interesting. Glad you fixed it. Sorry I didn't have anything better to offer.

One generic index should be best. If you had created multiple indexes, all with the same key values, you might not see them used even in the queries that suggested...

Just did a series of searches on both Bing and Google. There is no recorded instance that I can find of this part of the message:

"10.00.5500. That version is incompatible...

That should work. I've never heard about or run into issues restoring an R2 database from a 2008 backup. Just did some searching online. Everything I'm finding suggests it's pretty...

You do realize that indexes are absolutely wonderful things and extremely helpful in lots of situations? Lots of heap tables on a database sounds like a very questionable design. I'd...

Matt Miller (#4) (10/29/2014)

---

Grant Fritchey (10/28/2014)

---

The best way is to have a full script that does the restore and cleans up the database to remove or modify the data that...