I regretfully find myself in the 66% majority who answered this question incorrectly. Hopefully, all 529 of us learned something. I know I did. Thanks for the...

When the question says:

SELECT * FROM...

Jerry, hopefully someone will post a tidy explanation...

Thank you, Hugo. (The one that evaluates '\' as a number has compatability level 100. The other one has compatability level 80.)

Experimenting with the code in this question, I am getting different results from two SQL 2008 servers. One evaluates '\' as numeric. The other doesn't. They both...

The main point of the QOD about testing for equality of floating point data is an excellent one. But, I admit I am more fascinated by this:

Hugo Kornelis (8/26/2010)

---

...

Thanks for the SSIS question. Would like to see more of them!

Interesting. Very surprised to learn you can enter duplicate values when inserting explicit values.

Further surprised to learn that you can get duplicate values by resetting the identity...

Study the past if you would divine the future. ~Confucius

forjonathanwilson (7/21/2010)

---

A calculated field is not going to be A+B, because thats just a stupid test case. More likely a computed field will be connected to a UDF and be...

Only teasing...enjoyed the back-story! Didn't mean to distract from your main point.

Definitely learned something about NULL bitmaps. Your explanation was top-notch. By "performance" I was referring...

I was amused to see Sanjay and Mike D had the same thought process I did: Should John the developer be willing to risk the DBA's post-vacation wrath by...

Good QotD: Brief, straightforward illustration of something that may be well-known but was new to me.

I must be missing something. In Hrvoje's example, I understand why there...

For a SQL Server 2000 (and prior) dinosaur like myself, the whole concept of defining a Common Table Expresssion (CTE), never mind a recursive one, was new to me. ...

I did some online research to better understand how to use sp_MSforeachtable. I found this article to be very helpful:

http://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm

It contains this very simplistic example which clarified things for...