wolfkillj (11/12/2013)

---

My new blog post on appropriate data types for storing latitude and longitude coordinates is up.

Thanks for indulging me in a little bit of self-promotion. I'm finding that...

PHYData DBA (11/12/2013)

---

jfogel (11/12/2013)

---

I got it right not because I actually knew the answer but because I figured that the data (meaning common) pages would be fixed by automatic page...

So that one is in both places. Well found. I wonder why I couldn't find it.

Audio (HTML5)

Thomas Abraham (11/11/2013)

---

L' Eomot Inversé (11/11/2013)

---

... as far as I can tell it is nowhere documented that these 4 functions are additions to T-SQL in 2005; of course each has...

Simple straightforward question. Useful (while SQL 2005 is still in widespread use) because MS documentation on this is unsatisfactory.

I though the question would be difficult at...

Hugo Kornelis (11/9/2013)

---

L' Eomot Inversé (11/4/2013)

---

the explanation is wrong even when there is no join. It is unlikely that there will be a "unique sort", because there is no...

I don't know much about the US market, but I have noticed...

Mississippi - 3 single double letter combinations; Tennessee -...

Ed Wagner (11/8/2013)

---

Stefan Krzywicki (11/8/2013)

---

Teddy Roosevelt gave incredible access to reporters and encouraged them to root out corruption and problems....

Good QOTD. Quite a few people may learn from it, although I never could understand why people would misinterpret MAX.

It would make a good interview question - if...

kevin.l.williams (11/7/2013)

---

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

---

Point 5 in the explanation, although it is a direct quotation from BOL, is actually incorrect: the definition of @@rowcount is a bit more complicated that...

Good question.

It's generally not a good idea to leave the case sensitivity issue unspecified as a large number of people override the installation default so that use Model...

Good question.

Does the confict between the normal recommended cluster size for volumes holding filestream containers (64KB) and the size recommended for use when the filestream container is on a compressed...

steve.jacobs (11/5/2013)

---

L'Eomot,

Just for you, next time, if, like this one was "theoretical", I will certainly point it out in the description and the explanation. All, my apologies for...