Yes, it is a book, and I just download the PDF version of it from the...

Grant, Gail, thank you for the links. I spend a great deal of time on this site, reading as much as I can absorb, but there is so much. It...

Yay! I'm almost completely out to lunch on the subject of backups. I've been doing a full...

My two cents worth: there really isn't any need to have the word 'Column' in your column definitions. It just clutters up your SQL.

Elliott Whitlow (1/27/2012)

---

pdanes (1/27/2012)

---

NIC Teaming is where at least a pair of NIC...

Roy Ernest (1/27/2012)

---

You will have to check the server Specs to see how many channels it has. Usually there is one Internal IO card that will have two channels. This...

I'm not sure - how do I find out?...

Well, yes, but again, wouldn't that be served best by being able to physically separate the locations? With a RAID array, everything goes down one pipe, it's up to the...

Thank you both, that confirms my thoughts on the paid version of SQL Server - little point in having all that RAM and processors if they're not getting used.

But I'm...

Save yourself some time - just hire Gail.

So, let me see if I have this straight:

Dev DB

Simple Recovery mode

For each reload cycle:

- Empty and refill from live

- Checkpoint (to keep from bloating log)

- Backups not necessary, except...

http://www.mrexcel.com/forum/index.php

Looks useful, but I get an error on the reporting database name. Is it because I am using Express version, or can I do something to make it work?

Blanket prohibitions are generally a bad idea in any field. All processors have Jump instructions, which are low-level GOTOs, and high-level languages compile or interpret down to that, so your...