Viewing 15 posts - 5,116 through 5,130 (of 9,707 total)
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
I will let you argue the point with the man I learned this from, Brian Knight. Talk to him.
November 8, 2011 at 6:11 am
Stefan Krzywicki (11/7/2011)
... The repeated "DISTINCTS" are a little weird...
I've actually run into situations where I need duplicate DISTINCTs because of the way the data comes out of a complicated...
November 7, 2011 at 8:55 am
Koen Verbeeck (11/7/2011)
Stefan Krzywicki (11/7/2011)
But there isn't a 2008 SSIS forum!
No, but there is a general SSIS forum in the Data Warehouse section 🙂
(to be honest, that forum is not...
November 7, 2011 at 8:49 am
Viewing 15 posts - 5,116 through 5,130 (of 9,707 total)