good question.

I find the "inconsistency" discussion slightly odd. All operators/functions/operations/procedures have results/effects depending on the values of their parameters - but because dbcc checkident's effects depend the value of...

Nice question, but the reference provided in the explanation doesn't cover the only interesting point here, which is whether the variable is null after assigning the string 'TRUE' to it;...

fearful

SQLRNNR (1/21/2013)

---

Gianluca Sartori (1/21/2013)

---

On a totally unrelated note, what do you think of this person?

He's coming to Italy and my UserGroup is thinking about organising an event.

Would you pay...

Cole

Hugo Kornelis (1/21/2013)

---

... But in SQL Server 2012, there are definitely a lot of new function that are totally useless - except if you want to enable an easier transition...

Good to see another 2012 question. I hadn't read about Eomonth before, so had to read a BoL page and learn something new. 😎

It's mildly irritating though, having...

Dave62 (1/18/2013)

---

Try this:

1) Paste code into SSMS query analyzer

2)...

I think this is a question with a very wrong answer. Even wronger than Hugo suggests.

Hugo Kornelis (1/11/2013)

---

I don't really agree with the answer marked as correct.

NOT IN can...

It's an interesting question, and an interesting discussion. I'm glad I was too busy to look at it until just now, because I would rather have Hugo explaining this...

SQLRNNR (1/17/2013)

---

Hugo Kornelis (1/17/2013)

---

You are completely right - if you never make typo's, never have anyone else changing...

Good question, and the reference in the explanation is useful.

I answered it correctly because I remembered that a table keeps its pages until the index thy are a component of...

Sean Lange (1/15/2013)

---

Great question Wayne. I knew the page would not be deallocated but I didn't know all of the details. The article was very interesting and informative read.

I wonder...

WayneS (1/15/2013)

---

okbangas (1/15/2013)

---

As far as I understand it, there is something missing from the explanation. If we assume that only what's written in the scenario has happened, the scenario...

Nice straightforward question.

I find it a little irritating that try...catch is banned in multi-statement functions; I like to have clean eror management as much as possible, and cases where it...