Thanks for this good question.

Hany Helmy (9/24/2013)

---

Although I was pretty sure that this is another tricky question and my answer will be wrong when I pressed Submit button; but surprisingly it was correct 🙂

exec...

+1

Note that sp_filestream_force_garbage_collection is only available with SQL Server 2012. In previous editions there is not way to force garbage collection 😀

Nice 7-points worth question.

Thanks Steve!

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

The way the question works is that LEN requires a character string argument, so there is an implicit conversion from money or decimal to string. That...

Good but tricky question. Although just was question of pay attention to the fine print, as with legal contracts 😀

Primo Dang (7/4/2013)

---

I think a lot of people might...

Very positive knowledge acquired.

Thanks Hugo!

In fact, in SQL Server 2008 R2 an identity property is added too.

Easy one. And greats Hugo Cornelis's contributions.

I didn't observed this never before, and obviously I went wrong :pinch:

Thanks for this good question. Recently I realized this when i try to use TRY CATCH to validate an insert operation inside a table function.

Precedence in mathematical operations was the second theme I saw in my first day at the programming class. The first was data types in Turbo Pascal 3.0.

Thanks for making me...

Merry Christmas 🙂