Viewing 15 posts - 3,526 through 3,540 (of 18,926 total)
Thank you and your "senior".
Code like this allows guys like me to come back in after perf tanks and charge unhuman amount of $ for what I'm telling you free...
August 9, 2011 at 12:29 pm
ELEPHANT.
The first 4 inserts could be merge into a single one as far as I can see.
The FROM / where / group by seem 99% identical.
A couple well placed case...
August 9, 2011 at 12:27 pm
chandan_jha18 (8/9/2011)
GilaMonster (8/9/2011)
chandan_jha18 (8/9/2011)
August 9, 2011 at 12:20 pm
Just to be 100% clear.
This is NOT a sp with input parameters?
If I'm wrong here I'll need to full sp, not just this 99% sample.
P.S. This runs in 5 secs?...
August 9, 2011 at 12:19 pm
GilaMonster (8/9/2011)
chandan_jha18 (8/9/2011)
August 9, 2011 at 12:14 pm
chandan_jha18 (8/9/2011)
Ninja's_RGR'us (8/9/2011)
Yes, stats seem stale / wrong.The row estimate is 1 and the actual count is over 100K iirc. That's why we're all pounding on this one.
As per...
August 9, 2011 at 12:05 pm
Insert into base...
SELECT FROM qry .... WHERE NOT EXISTS (SELECT * FROM base where qry.id = base.id)
August 9, 2011 at 12:03 pm
chandan_jha18 (8/9/2011)
August 9, 2011 at 12:02 pm
Yes, stats seem stale / wrong.
The row estimate is 1 and the actual count is over 100K iirc. That's why we're all pounding on this one.
August 9, 2011 at 11:59 am
The requirement is also NOT to close the currently opened windows.
There's a reason that debate lasted over 100 posts in that other thread. There's no simple, easy solution ;-).
I'm...
August 9, 2011 at 11:57 am
chandan_jha18 (8/9/2011)
Ninja's_RGR'us (8/9/2011)
Did you update with fullscan, if not by what %?
I just ran:
exec sp_updatestats.
Do i need to modify this statement. please advice.
Just FYI. Following are the number of...
August 9, 2011 at 11:47 am
I'd still like to see th whole SP.
In the mean time you could experiment with this >
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries
You seem to be fine here, but I would also change to inner joins....
August 9, 2011 at 11:45 am
Welcome to 2k5 +.
It was still like you expected in 2000.
August 9, 2011 at 11:40 am
http://www.sqlservercentral.com/stairway/72382/
And for that particular problem you simply have to use subreports.
August 9, 2011 at 11:20 am
Viewing 15 posts - 3,526 through 3,540 (of 18,926 total)