Good question, genuinely back to basics, but as your int value was 32767 wouldn't 32512 have been a better distractor than 65280?

jasona.work (7/1/2013)

---

OK, where I work, it seems that when they were remodelling (before I started) they "fixed" the air conditioning...

As in, one of the old hands stated where I'm sitting...

Revenant (7/1/2013)

---

L' Eomot Inversé (7/1/2013)

---

. . . The very earliest floating point hardware implementation (Zuse, 1941) was neither electronic nor part of a stored program computer and had much...

spices

You say no index, but did you specify a primary key? If so you have an index.

Hugo Kornelis (7/1/2013)

---

(By the way, I think real should be considered to have maximum precision six; you should always calculate with at least one more digit then the precision to...

Hugo Kornelis (6/30/2013)

---

SOUNDEX and DIFFERENCE can be useful, but you have to know their specifications. Here is...

garden

ronmoses (6/28/2013)

---

It doesn't strike me as a particularly useful function, especially given these examples:

SELECT SOUNDEX('cent') --C530

SELECT SOUNDEX('scent') --S253

SELECT DIFFERENCE('cent','scent') --2, a very weak match

SELECT SOUNDEX('through') --T620

SELECT SOUNDEX('threw') --T600

SELECT DIFFERENCE('through','threw')...

AA Guns

kapil_kk (6/27/2013)

---

Same here...

I dont think there is any need of using...

I'm not at all surprised people don't know. Most DBAs probably have only one data file...

Me too, having...

GilaMonster (6/25/2013)

---

No idea about Swahili, since it's not native to my neck of the world, but Zulu is correctly written as isiZulu when writing in the language, not Isizulu. It's...

Jan Van der Eecken (6/14/2013)

---

dwain.c (6/13/2013)

---

Sean Lange (6/13/2013)

---

WayneS (6/13/2013)

---

dwain.c (6/12/2013)

---

I can only imagine what it must be like to have SQL Server running in some non-English language. MS probably...