I always name my tables plural and my columns singular. Table name is Books, the column that contains the book's title is...

First questions that come to mind.

What's the database for?

What's going to be stored in it, for how long and why?

Who's going to be using this and how?

I would argue with that. The best place for the clustered index...

It's a server-wide permission. Traces aren't database objects, they trace the entire instance.

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...