Bob Hovious (2/11/2009)

---

A useful general rule, but not always possible to implement:

* When one of the columns in the candidate key is nullable

* When there is no candidate key (no...

I'm coming rather late to this, most of my desired enhancements have already been mentioned and about those I'll say no more than that I agre with everything Jeff M...

Iggy (1/21/2009)

---

igorg (1/21/2009)

---

I agree with Warren. In MSDN its clearly written that msdb.restorehistory contains one row for each restore operation.

For VERIFYONLY restore option column [restore_type] will contain 'V'

V =...

DPhillips (5/11/2009)

---

I still have never run into an instance where it was necessary for a piece of code to modify itself, but this borders on wild frontiers where code can...

My take on ths is that SQL 2008 has introduced a serious defect! Changing to behave in this irrational manner has probably broken rather a lot of SQL. ...

Christian Buettner (6/5/2009)

---

I had chosen char(1) instead of varchar(1) because thats what it actually is, a fixed length string.

And I had chosen char(1) instead of nchar(1) because I think it...

Steve Jones - Editor (6/16/2009)

---

DNS and DHCP servers do need to respond quickly, but they have low resource requirements, and I've seen many people virtualize these easily.

Going to a VM...

SQAPro (6/16/2009)

---

Tom.Thomson (6/16/2009)

---

CTD? ok you've stumped me, Circling the Drain? Close to Death? Cheaper Than Dirt? what's your meaning here? I hope I don't...

I agree too, about not liking unnecessary parentheses. But I can hazard a guess as to why people...

Another sloppy question :angry:. It should read "What is the ISO name ...", but as the correct answer to the question as it stands ("nvarchar") isn't one of the...

The answer is nonsense! The character might well be a Chinese one and that will not fit into char(1) or varchar(1). I work daily with text data that...

Suggesting that "Simple servers, such as DNS, DHCP, or Active Directory Servers" are going to be easy for virtualisation seems to me a bit strange. Anyone who has to...

Manie Verster (5/11/2009)

---

GilaMonster (5/11/2009)

---

Manie Verster (5/11/2009)

---

I never see any articles about bad DBA's, no sirree. They are the good guys. The people that so arduosly defend their databases against developers...

Most of the problems I most often have with developers are the same as the problems I most often have with DBAs. heres a list of what I think...

Oh dear, what makes you...