Viewing 15 posts - 5,131 through 5,145 (of 9,726 total)
Ninja's_RGR'us (11/11/2011)
Roy Ernest (11/11/2011)
Brandie Tarvin (11/11/2011)
EEEK! I just sold another story. Happy happy.Now I have to write more.
Congrats Brandie. Wonderful job. 🙂 You can stop working as a DBA...
November 11, 2011 at 7:51 am
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....
November 11, 2011 at 7:31 am
EEEK! I just sold another story. Happy happy.
Now I have to write more.
November 11, 2011 at 7:28 am
Glad you found a solution, even if it doesn't help you right now.
November 11, 2011 at 6:24 am
SQL Kiwi (11/11/2011)
Ninja's_RGR'us (11/11/2011)
Cancel that... seems like the upgrade failed.Who said there was no risk? :hehe:
No-one - the phrase was "pretty small risk".
It works 99.99% of the time.
...well, okay....
November 11, 2011 at 5:09 am
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...
November 11, 2011 at 4:55 am
Would you actually be using a WHERE clause IRL?
Or does the WHERE clause exist only to limit your row values at the moment?
November 10, 2011 at 8:57 am
SQLRNNR (11/10/2011)
Stefan Krzywicki (11/10/2011)
Kiara (11/10/2011)
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...
November 10, 2011 at 8:26 am
Ninja's_RGR'us (11/10/2011)
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...
November 10, 2011 at 8:23 am
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...
November 10, 2011 at 8:21 am
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 I delve...
November 10, 2011 at 8:11 am
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...
November 10, 2011 at 8:07 am
Stefan Krzywicki (11/9/2011)
I didn't have any problems when I submitted my articles. I did it through the editor. I guess I got lucky.
It's been a while since I've submitted, but...
November 9, 2011 at 11:50 am
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....
November 9, 2011 at 8:18 am
GSquared (11/9/2011)
GilaMonster (11/9/2011)
Ninja's_RGR'us (11/9/2011)
Am I the only 1 who wants to answer... if you don't know that, then why are you teaching this stuff??http://www.sqlservercentral.com/Forums/Topic1202806-150-1.aspx
Haven't you forgotten the old saying -...
November 9, 2011 at 8:07 am
Viewing 15 posts - 5,131 through 5,145 (of 9,726 total)