I have a potential customer who wants to migrate his SQL 2000 environment from an "old" server to a new server keeping the SQL 2000 environment because of the custom...

Estuary English - Ah want a gloss of miwk

Often falsely identified as a type of cockney,...

Oh I was tempted by the 4th choice thinking it might be a trick question 🙂

Great question! I bet you would find disagreement inside many organizations...

...a-ha-ha-hand learning

...a-ha-ha-hand learning

...a-ha-ha-hand learning

...a-ha-ha-hand learning....

Great question!

And miles...

86 (as in 86ing the old sql 2000 box...)

Sober

Tom.Thomson (4/29/2011)

---

UMG Developer (4/29/2011)

---

Duh, I was missing the obvious issue by paying more attention to the MAX portion. You are right, there would be no point in declaring it as...

cfradenburg (4/29/2011)

---

Tom.Thomson (4/29/2011)

---

Arrgh!! I see 36% got it wrong. I hope no-one feels too insulted by the above. But can it be true: 36% of SQLServerCentral subscribers are...

Tom.Thomson (4/28/2011)

---

Peter Trast (4/27/2011)

---

OK, here is the fix for hardcore 1NF fans. One column, long text datatype (pick your fav) like concatenating an entire name if there is no use...

Lucky guess for me and a great question! Another interesting tidbit.

A word of advice for everyone who is interested in these little morsels of SQL filler.

Read the MCM reading list....

Steve Jones - SSC Editor (4/28/2011)

---

It's a fairly arbitrary concept and with conflicting information on the calculations, it's hard to understand what is correct. The way that it's given in...

Chris Umbaugh (4/28/2011)

---

When attempting to learn the effective max% concept I read the following SQLServer Central article which I find misleading (at least as I interpreted it): http://www.sqlservercentral.com/articles/Resource+Governor/64034/

It...

GSquared (4/27/2011)

---

Peter Trast (4/27/2011)

---

Steve Jones - SSC Editor (4/27/2011)

---

I may be wrong, and I'll admit that. However the "use" of the data in terms of when/how you might call someone...

GSquared (4/27/2011)

---

Richard Warr (4/27/2011)

---

Nice question and an interesting example. Would renaming the columns "Telephone 1" and "Telephone 2" to "Home Phone" and "Mobile Phone" mean that the table was then...