Does anyone have a...

I agree with the people who say that "by default" only allows answers "yes" or "no", but by giving 2 other options, I think most people would ignore the prefix...

Rajan John (4/18/2008)

---

Are we looking too much into the questions and answers provided? Or do we think that the questions should be accurately deterministic? I believe a healthy debate/discussion is...

Habit. 🙂

Novices start by firing up SSMS and running every...

Mike Dougherty (4/17/2008)

---

If we're looking for obscure/inefficient ways to produce the requested output:

...

I think if we're going to be challenged with writing different SQL, it should be to produce more...

"select * from sysprocesses" works in 'master'. In any other database I need "select * from sys.sysprocesses". SSMS only highlights it if it's got the sys prefix.

I also found that you can't just query sysprocesses (unlike sysobjects), you have to specify sys.sysprocesses.

For info, I analysed some of our data by number of statuses a document went through and then added a '% time' based on the assumption that the time was...

Matt Miller (4/16/2008)

---

For what it's worth - the update method for forcing order will fall apart with a parallel plan, so don't change the MAXDOP on the test I gave...

There was an error here...

What should the line have been?

I ran some tests measuring the elapsed (from datediff(ms,,getdate())) and cpu (from @@cpu_busy*@@timeticks) times on both my laptop and the server where this application resides.

I generated 500,000 series which generated...

Jeff Moden (4/15/2008)

---

Can the data generator code you provided be used to generate that many rows? I'd like to "play" some more because 41 to 45 seconds to...

I created a couple of test queries using the real data based on Peso's method and using row_number().

After several tests, Peso's method was fractionally faster (41015ms) than the triangular/diagonal join...

John Portnov (4/15/2008)

---

How does it satisfy a requirement if Feb can have an even or odd number of days, depending if it is a leap year? This solution is...

Robert (4/15/2008)

---

Right, but Steve once mentioned that QoD is not about best practices. Some are about bad practice, probably to spark discussions like this, which is OK for me.

If the...