bitbucket-25253 (1/29/2013)

---

davoscollective

A lot of people are complaining about not having SQL Server 2012 or Adventureworks on production machines. I have a test/dev VM with SQL Server 2012 SP1 and both...

Thank you...

Don't have AdventureWorks either... 🙁

Oh my, why is this question still wrong in January?!? 🙁

Hugo Kornelis (12/23/2012)

---

While hunting for this information, I did find a few Connect items about errors with WHEN (something that's never true) THEN MIN(1/0) or WHEN (something that's always true)...

OK, I hate to start nitpicking, but the correct answer is missing:

For 7 rows you definitively need NO index to improve performance 😛

I too would have liked an explanation for the purpose of "FOR BROWSE" in relation to that DMV.

At the moment the new "knowledge" about this DMV is useless, without knowing...

L' Eomot Inversé (12/17/2012)

---

Mosty a good question, apart from the awful misprint - the table would not be created unless that was corrected!

To all those talking about select being atomic:...

I was also quite surprised to see this answer...

Good question, but the explanation is not helpful... Where is the BOL link for this?!?

I don't want mess up dinner because the function doesn't work as expected...

Raghavendra Mudugal (11/9/2012)

---

Msg 4127, Level 16, State 1, Line 8

At least one of the arguments to COALESCE must be an expression that is not the NULL constant.

.. possibly just missing...

Good question, but wrong explanation (and also wrong error message from SQL Server):

Simple example that...

It would be new to me that sp_configure is an extended stored procedure.

I think it is just a normal system stored procedure.

But still a good question:)

Lisa Slater Nicholls (9/14/2012)

---

The problem here...

I think this "could" be solved using a CLR function that tries to cast the value to each acceptable numeric data type, but I never did CLR.

Unfortunately you cannot do...