lmu92 (2/22/2010)

---

:blush: I missed the SET DATEFIRST part in your code and I also screwed up regarding DATEFIRST =7 and DATEPART(WEEKDAY, DateVal)=1 to be Monday... :blush:

So, let me rephrase my...

If it helps, this is a version that produces the same results and execution plan, but with a perhaps more obvious structure:

DECLARE @data

TABLE (

...

Jeff Moden (2/22/2010)

---

Send it to me... we had a sequence table that was responsible for an average of 640 deadlocks a day before we fixed it. I'd love to...

Confirmed on the 2005 installation I referenced before. BUT this is just a decoding/display problem in DBCC PAGE with type 3 output - the data is there in the...

WayneS (2/22/2010)

---

Now, the results from this deviate ever-so-slightly from the expected results as specified in this post... specifically for value_date_minus_1 value 12/12/2008. In #tmp_Dates1, it looks like the last date...

No worries, Hari - I enjoyed writing the reply. It would be cool if you would just post your questions in one forum...

Well I don't know exactly what the criteria are, but Barry strikes me as a strong candidate...

RBarryYoung (2/22/2010)

---

Hey! I almost missed this, but Itzik Ben-Gan gave me kudos in his column this month for solving on of his 'unsolveable'(?) puzzles! How come no one...

Steve Jones - Editor (2/22/2010)

---

You certainly are, and just because there's an article out there doesn't mean we wouldn't want one here. Especially from the famous Paul White.

Be sure to...

I only have SQL Server 2005 SP3 CU7 version 9.0.4273 installed, I'll test it on that later.

eddy-644184 (2/22/2010)

---

Seems like a very clever idea. Im going to save this post for later use, could come in handy.

PS: Didn't you miss deleting the triggers also once the...

Andrew Gothard-467944 (2/22/2010)

---

anyone prepared to bet against something along the lines of "The developers ... every text field is nvarchar(max) ... performance terrible ... I've been asked to tune...

Chris Morris-439714 (2/22/2010)

---

Paul, I look forward to checking out your link later at home, it's probably classed as "restricted" here. OTOH, our company website is probably classed as "restricted" where...

Me too - I still struggle with it to be honest.

I...

I took it as such - it was just unexpected. Thank you...