Jack Corbett (11/11/2011)

Congrats! I don't know how you do it AND keep up with...

Ninja's_RGR'us (11/11/2011)

Roy Ernest (11/11/2011)

Congrats Brandie. Wonderful job. 🙂 You can stop working as a DBA...

The transaction will continue to run until it's completely rolled back. Rollbacks can take a while, just like the initial execution. It depends on how far the initial transaction went....

EEEK! I just sold another story. Happy happy.

Now I have to write more.

Glad you found a solution, even if it doesn't help you right now.

It works 99.99% of the time.

...well, okay....

If you can resolve the problem by moving your WHERE clause, though, is it really that big of a deal?

I personally think you should upgrade to SP4, BTW. I'm just...

Would you actually be using a WHERE clause IRL?

Or does the WHERE clause exist only to limit your row values at the moment?

SQLRNNR (11/10/2011)

Stefan Krzywicki (11/10/2011)

Kiara (11/10/2011)

Stefan Krzywicki (11/10/2011)

I inherited a query like that back in 99. It...

Ninja's_RGR'us (11/10/2011)

Brandie Tarvin (11/10/2011)

Gave it an initial shot. Want to see what your answer is...

When you have time...

What exactly is the data supposed to be? Product data? What do the dates mean for the data? (I'm looking for the English explanation here so I...

Gave it an initial shot. Want to see what your answer is before I delve...

Remi,

Silly question. Why are you turning an OUTER JOIN into an INNER JOIN by adding C2.NoArticle to your WHERE clause?

Would that have anything to do with your issue?

EDIT: I'm not...

It's been a while since I've submitted, but...

If you've never done load balancing testing before, I suggest you don't schedule the reports to run simultaneously until after you've taken a baseline performance test of each individual report....