I'll let you know how that...

Indeed, Steve...http://blogs.msdn.com/bartd/archive/2008/09/24/today-s-annoyingly-unwieldy-term-intra-query-parallel-thread-deadlocks.aspx

Hugo's Blog About Cursor Performance

Wow! Awesome...though actually I think I'd have the mint original - it's currently parked 5km up the road from here in a...

GSquared (1/11/2010)

---

Pick the right one, and let them answer to HR for why they called that number from their desk. Let them assume the number listed has anything whatsoever...

xkcd just gets better!

This is the car I'd have:

Peter Brinkhaus (1/11/2010)

---

Paul White (1/11/2010)

---

Quite so - it's just that the result of the ABS(SIGN(B)) is only used in the ORDER BY part of the ROW_NUMBER ranking function, so I...

Interesting. I'm going to run some tests on my home instances to see if I can replicate this.

Oddly, this is slightly reminiscent of something I half-remember from years ago...

Curiosity got the better of me...smaller PNG version attached.

edit: And now I have looked at it. It's a screenshot of a blocked/blocking transaction report in SSMS. It...

Peter Brinkhaus (1/11/2010)

---

The SIGN part isn't required if the only values of B are -1, 0 or 1 as in the new testset the OP posted. However, the OP also...

Can I ask if you have run Profiler traces to capture the execution plans?

It would be good to know that the plans are exactly the same when run from the...

Lynn Pettis (1/11/2010)

---

May suggest in the future you provide a more complete test suite of data? The code initially provided did meet the original requirements based on the sample...

ifila (1/10/2010)

---

SELECT COUNT(DISTINCT(variablename))

Let's assume i have 1000 variable names, with duplicates, which is why i need DISTINCT.

I only want to display the TOP 50.

SELECT TOP 50 COUNT(DISTINCT(variablename)) does...

1. Switch the database to BULK_LOGGED mode

2. Rebuild the index(es)

3. Switch back to FULL recovery

4. Immediately backup the log

Rebuilding indexes in this way will ensure that...

Thank you 🙂