According to BOL, [Bitwise Operations (Transact-SQL) bitwise operations don't support bigint; in practise (in SQL 2012 anyway) you can mix and match bit,...

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...