GSquared (12/30/2011)

---

I've fielded about a dozen forum questions about locking over the last couple of weeks, and in one of them, someone asked me to write a common-language article on...

roryp 96873 (12/30/2011)

---

Thanks Paul, I haven't made it through the comments in that article yet, but I will be sure to read through them. That error came from me...

Some general comments:

I agree with Craig that the current indexing arrangement is probably not optimal for these lookups. A narrow unique index on the loyalty identifier that (implicitly or...

roryp 96873 (12/29/2011)

---

After reading Jeff Moden's article that Drew suggested (which was straightforward and very helpful), I came up with this solution. The problem is that it will only...

A SQL Server 2012 solution, for comparison's sake:

DECLARE @data TABLE

(

item INTEGER NOT NULL

)

;

INSERT @data

(item)

VALUES

(60),

...

That would be cool, but SQL Server does not...

DECLARE @time TIME = '20:10:10'

SELECT total_seconds =

DATEPART(SECOND, @time) +

60 * DATEPART(MINUTE, @time) +

3600 * DATEPART(HOUR, @time)

True - but this was a change (in 2005) so for many people the change in behaviour will still...

It's always worth re-doing, it catches a lot of people out (and no-one reads these comments anyway :-))

I love it when a (only slightly educated) guess pays off 🙂

Hugo Kornelis (12/27/2011)

---

...the ISNULL expression could be rewritten [...] maybe this will indeed happen if the table is large enough to warrant using all phases of the optimizer to do...

For anyone wondering about the cryptic comment in the UPDATE statement:

UPDATE dbo.Event

SET EndDate = DATEADD(dd,

...

There's always a temptation with QotD to keep expanding it until the question is 'perfect'. This question seems to have fallen victim to that temptation; in attempting to cover...

Interesting - I cheated, obviously, and found there are nine, but it appears eight is also right:

http://en.wikipedia.org/wiki/Santa_Claus%27s_reindeer

Americans. Sigh.

Happy Christmas, wherever you are. Off to find some forum questions to replace the seven points missed here today.