Viewing 15 posts - 5,131 through 5,145 (of 9,722 total)
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
Talk to the people who set up SSRS for you. Ask them to help you load test this.
November 9, 2011 at 8:02 am
FYI
Here's an article on Denali prices and licensing info:
November 8, 2011 at 8:47 am
Roy Ernest (11/8/2011)
I am planning on a presentation for my user group "DBA MythBusters" (Courtesy Paul Randal) His idea is...
November 8, 2011 at 6:21 am
Sean Lange (11/7/2011)
Brandie Tarvin (11/7/2011)
Sean Lange (11/4/2011)
November 8, 2011 at 6:16 am
Viewing 15 posts - 5,131 through 5,145 (of 9,722 total)