See my...

Got the answer by deduction and removing the obvious wrongs ones, but I do not like the question.

COUNT, as any other aggregate, ignores NULL values.

COUNT(*) is special. The * means...

Good question.

Small addition to the explanation: the second option (UNION instead of UNION ALL) will actually reduce performance, because in addition to reading data from both tables, SQL Server now...

A nice and easy question, but the explanation is not fully correct.

Allthough Books Online does not explicitly document this (or I overlooked it), ISNUMERIC is a function that expects a...

Jeff Moden (12/28/2014)

---

The link for the "poor documentation" that I was speaking of is actually in Books Online under UPDATE... as in "Quirky Update", which can be controlled but is...

The most relevant documentation beinig this one: http://support.microsoft.com/kb/287515: Execution Plan and Results of Aggregate Concatenation Queries Depend Upon Expression Location. This article from...

Lynn Pettis (12/26/2014)

---

Hugo Kornelis (12/26/2014)

---

...

(And technically, when the variable in declared but not initialised, the code will still "find" the stored procedures and functions with a name starting with sp_...

PHYData DBA (12/26/2014)

---

There are places where the M$ TSQL does not follow the ANSI SQL standard.

MHO: The IN operator and using the NOT qualifier with it are "NOT...

For the nitp^H^H^H^H literelist, the question does not ask what other code needs to be present in order for this to work, just what it does.

(And technically, when the variable...

Jamie-2229 (12/26/2014)

---

Yep, you're right. So if you are using an "IN" or a "NOT IN" statement, not only is it faster to join than use "IN" or "NOT IN",...

I picked the least incorrect answer and got my points. But the answer is still wrong. The more correct answer would be that it finds all stored procedures that start...

SQL-DBA-01 (12/26/2014)

---

Getting this error:

Msg 208, Level 16, State 1, Procedure GetIt, Line 7

Invalid object name 'T'.

Msg 15165, Level 16, State 1, Procedure sp_recompile, Line 19

Could not find object 'T' or...

For those who, like me, had to spend more time than they are willing to admit to understand the logic, here is a breakdown.

- datediff(yy,-1,getdate()) --> The integer -1 is...

g.britton (12/24/2014)

---

..as I said. ...

In this case, it does. But don't rely on that. For any query with a bit more...