A question about SQL today! Well done, and thanks.

@@error is a bit less relevant these days (TRY/CATCH) but it's still a good general-knowledge question.

Hugo Kornelis (4/23/2010)

---

I got it right, but I don't like the question.

The QotD should be about testing our knowledge of SQL Server. Not testing our ability to use a search...

Aleksandar Cebov (4/26/2010)

---

What if we need to do server side paging and sorting and apply filter on which rows should be returned (maybe in the example I need to...

Well hopefully you found something interesting or useful - if not, perhaps you will...

desade (4/26/2010)

---

any idea why key seek method uses much more CPU for 10 pages then it uses for 100 or 200? It looks as some glitch in testing, but maybe...

It works whenever there is a useful index to obtain the keys,...

Try:

SELECT COUNT(t.AIID)

FROM boc.POSKit p

RIGHT

JOIN boc.Terminal t

JOIN boc.Merchant m

ON ...

Jeff Moden (4/24/2010)

---

In the presence of SET XACT_ABORT ON, any runtime error will cause all of an explicit transaction to ROLLBACK auto-magically. From Books Online...

When SET XACT_ABORT is ON,...

Stefan_G (4/24/2010)

---

OK, I should have known better than to challenge you like that. Well done. 🙂 I now officially give up. I realize that I will not be able...

The simple answer is that the 2008 optimiser has a lot more options than in 2000. In this case, 2008 picks a poor plan which was not available in...

A good summary of the available methods here:

http://florianreischl.blogspot.com/2010/01/concatenation-of-text-and-binary-data.html

The point of TRY...CATCH is to give you an opportunity to handle errors...

Stefan_G (4/24/2010)

---

What this demonstrates is that this bug makes it impossible to write an ITVF that implements the desired semantics. We have alread have this discussion with your SafeDateAdd. My...

Perry Whittle (4/24/2010)

---

...This is essentially a personal preference and as Slava points out if SQL is really that memory bound you may want to consider adding more RAM, rather than...

Tao Klerks (4/23/2010)

---

Hugo Kornelis (4/23/2010)

---

The log file will contain only the fact that page so-and-so was deallocated, but the log backup (if one is taken) will also include a copy...