Don't confuse primary key and clustered index. I wasn't questioning your PK (although I could, :w00t: ). I like to think about how the data is going to most often...

The question for me is, what are you planning on clustering on? Based on your post, I'd suggest the combined index, not the PK, because that sounds like it's going...

and that's why every database should be stored in source control just like application code.

Is the process run nightly and only Sunday failed? If so, like everyone else said, hit the logs and look for the cause. If not, look to the process.

Even if it were possible, the differences between them would be essentially the same as between the others.

How about normalize appropriately?

For a datawarehouse? I'd suggest looking at a star schema. I'd consider that normalized, but not necessarily in third normal form.

AlexSQLForums (7/18/2011)

---

Grant Fritchey (7/18/2011)

---

AlexSQLForums (7/14/2011)

---

I usually use DTA when i have no documentation about a database that's having performance issues.

it does recommend creating indexes on every column in the where...

Jayanth_Kurup (7/18/2011)

---

Having just tried it , i noticed something that might be of interest.

If SQL is already compressing the backup then using winzp or winrar doesnt do a great job...

AlexSQLForums (7/14/2011)

---

I usually use DTA when i have no documentation about a database that's having performance issues.

it does recommend creating indexes on every column in the where clause and depending...

You scared me very badly. I can't imagine saying that DTA would do a better job than an experienced DBA.

Personally, I'm extremely underwhelmed by what the DTA delivers. Is it...

Like Gus says, just use the command line. To set it up automatically, just use SQL Agent and have one step that does the backup and, assuming successful completion of...

I'm very confused by the question. You're talking about backups, result sets and ISNULL all at the same time. They're not really related to one another.

If the app is getting...

jmaia (7/12/2011)

---

Ninja's_RGR'us (7/12/2011)

---

It's not basic at all actually.

I'm no expert in waits but I'll hang around if I can help more.

What's the normal use of the system? OLTP, OLAP,...

Thanks. I hope it's helpful.

CDA (7/11/2011)

---

first great book; thanks for the free download.

I've passed this on to my team for recommended reading.

second question: why does the word Kindle in front of Ebook bump the...