Viewing 15 posts - 241 through 255 (of 429 total)
Grant Fritchey (8/22/2011)
August 22, 2011 at 12:00 pm
Actually I should have been more precise and accurate here. The above query is actually a view and in my procedure, there are some filter operations in where clause. I...
August 22, 2011 at 10:51 am
Sachin Nandanwar (8/12/2011)
See whether this helpshttp://support.microsoft.com/kb/975752/en-us?sd=rss&spid=13165
It does not let me run this CU. I have repaired the shared features in SQL installation through repair wizard. I have rebooted it and...
August 12, 2011 at 4:13 am
I know replication a a bit tricky subject. So I am requesting all of you to atleast give some hint even if you do not know the complete answer.
August 11, 2011 at 4:46 am
Ignacio A. Salom Rangel (8/11/2011)
You can use the steps in this link. Good luck!
Big daddy. you are correct. Some forums suggested to use detach attach method for system databases using...
August 11, 2011 at 3:47 am
Ninja's_RGR'us (8/9/2011)
Let's try to clean this mess up.
Take the first query. Start using joins,...
August 9, 2011 at 2:02 pm
Ninja's_RGR'us (8/9/2011)
chandan_jha18 (8/9/2011)
Ninja's_RGR'us (8/9/2011)
Do you have the new execution plan? At least we can see how we can...
August 9, 2011 at 1:35 pm
GilaMonster (8/9/2011)
Use profiler, use Statistics IO, use statistics...
August 9, 2011 at 1:34 pm
I did'n use the profiler. I ran the whole procedure once and then found that each batch was taking almost 20-25 percent in the execution plan. So i just picked...
August 9, 2011 at 1:25 pm
Ninja's_RGR'us (8/9/2011)
I stopped asking why many moons ago.. just give you headaches ;-).Do you have the new execution plan? At least we can see how we can help there.
Last...
August 9, 2011 at 1:19 pm
Ninja's_RGR'us (8/9/2011)
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...
August 9, 2011 at 1:05 pm
GilaMonster (8/9/2011)
chandan_jha18 (8/9/2011)
August 9, 2011 at 12:17 pm
Ninja's_RGR'us (8/9/2011)
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...
August 9, 2011 at 12:15 pm
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 the...
August 9, 2011 at 12:03 pm
If a plan has seek operators, does it mean that it is good enough? My plan has so many scalar operators too. Not sure what to make out from the...
August 9, 2011 at 12:00 pm
Viewing 15 posts - 241 through 255 (of 429 total)