Two options. which you take depends on how critical the data is in this database. Do you need to be able to restore the database right up to the second...

I haven't done any integrating with Reporting Services myself. I know it can be done, but that's about all. I just use it as an automated report delivery tool.

Maybe post...

Ouch. Those are way out of expected.

sec/read and sec/write should be below 0.01 sec

% disk idle time should ideally be >75%

I'm curious how the %disk time managed to exceed 100%....

the biggest downside to table variables is that indexes cannot be aded to them (apart from a primary key) and that they don't keep data distribution statistics.

The second is often...

It might be the SAN. What did the perf mon counter values look like?

If you've identified high IO using queries, see if there's anything you can do to reduce the...

Yes, absolutely. IME, the worst fragmentation you get is at the leaf levels of a clustered index, and is the most necessary to rebuild. The higher levels of indexes generally...

Rebuild is functionally the same as dropping the inex and recreting it. It rebuild all of the leaf and non-leaf levels of the index.

Reorg just removes fragmentation at the leaf...

🙂 I've got several tables...

Backup the tail of the transaction log (backup log to file="..." with NORECOVERY, NO_TRUNCATE)

Restore your full DB backup with no recovery.

Restore your Diff backup with no recovery (if applicable)

Restore all...

For transactional replication, there must be a way to uniquely identify each row of a replicated table, so that, when changes to a row are replicated to the subscribers, there's...

James Horsley (11/16/2007)

---

No wonder it was faster ....

If any of the variables are Null if will be doing a compare with a Null which is a no no -- perhaps...

The problem with all of those 'all-in-one' type queries is that they make query plan reuse a very dodgy affair. What may be suitable for one set of parameters often...

Normally I'd suggest RCSI if lots of blocking is seen. It's not going to reduce IO load, and may even increase it, due to increased usage of TempDB.

If you can,...

From your description, the temp table sounds better, providing there are appropriate indexes on it. Depends on tempdb space, activity, memory size, ...

My normal answer to questions like this is...

Matt Miller (11/15/2007)

---

Gail - as to your test - I will try to dig out and use the XML data() trick, we'll let Jeff come up with the "pure" T-SQL...