Viewing 15 posts - 1,426 through 1,440 (of 18,926 total)
Brandie Tarvin (11/10/2011)
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...
November 10, 2011 at 8:25 am
Brandie Tarvin (11/10/2011)
Ninja's_RGR'us (11/10/2011)
Got another puzzle for you guys and possibly another bug (row_number, partition by & cte).http://www.sqlservercentral.com/Forums/Topic1203532-266-1.aspx
Gave it an initial shot. Want to see what your answer is before...
November 10, 2011 at 8:20 am
Tx again for all your support.
November 10, 2011 at 8:18 am
SQLRNNR (11/10/2011)
SQL Kiwi (11/10/2011)
Ninja's_RGR'us (11/10/2011)
Actually I caught the very moment it happened!You need a hobby.
I think he has a hobby. He needs a new hobby.;-)
I have one, but summer's...
November 10, 2011 at 8:17 am
Brandie Tarvin (11/10/2011)
Remi,EDIT: I'm not sure what to put as the second argument here, but you could try:
ISNULL(C2.NoArticle,C1.NoArticle) = '10A-057-0'
Not what I need in the final query but for the...
November 10, 2011 at 8:14 am
Brandie Tarvin (11/10/2011)
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?
I...
November 10, 2011 at 8:13 am
Yes, but I would consider 2 things.
How long to update the stats?
Also why not schedule the stats updates in a job as frenquency requires?
November 10, 2011 at 7:53 am
14 day trial of this good tool => http://www.red-gate.com/products/dba/sql-monitor/
November 10, 2011 at 7:48 am
dirty reads = bad data. It's flat out automatic that it will happen. How often? Your guess is as good as mine.
Moreover there's an inevitable case where...
November 10, 2011 at 7:42 am
Got another puzzle for you guys and possibly another bug (row_number, partition by & cte).
http://www.sqlservercentral.com/Forums/Topic1203532-266-1.aspx
November 10, 2011 at 7:38 am
At least it is formatted : -)
And of course there's 2 versions, you wouldn't want to miss the chance to call the wrong one!
Wouldn't be the worst thing. ...
November 10, 2011 at 7:21 am
Stefan Krzywicki (11/10/2011)
Kiara (11/10/2011)
In case y'all haven't seen this.. http://thedailywtf.com/Articles/The-Query-of-Despair.aspx...I'm sure we've all had days like that...
I inherited a query like that back in 99. It was a 500 line...
November 10, 2011 at 7:13 am
Kiara (11/10/2011)
In case y'all haven't seen this.. http://thedailywtf.com/Articles/The-Query-of-Despair.aspx...I'm sure we've all had days like that...
Yup noone WANTS to help... if they could.
Reminds me of the first billing system I wrote....
November 10, 2011 at 7:08 am
Viewing 15 posts - 1,426 through 1,440 (of 18,926 total)