Viewing 15 posts - 1,861 through 1,875 (of 18,926 total)
tfifield (10/19/2011)
Indexes fragmented more than 30% really should be rebuilt rather than reorganized.Todd Fifield
Unless you need to keep the table online and don't mind having it run longer ;-).
But ya...
October 19, 2011 at 11:45 am
Hard to tell without the actual execution plan.
My guess is that the server has a better guess at the amount of rows returned and choose a different plan.
October 19, 2011 at 11:44 am
Can be also because you didn't specify the owner.
Changed the case in the name of something.
cachemiss is real easy to get ;-).
October 19, 2011 at 11:37 am
You can use this variable in the file name to put the date. That's pretty much all the customization you can do tho.
@timestamp
October 19, 2011 at 11:34 am
DMarvez (10/19/2011)
We'll pass along this suggestion and the warning that there...
October 19, 2011 at 11:32 am
Don't know about drop but you can disable the account. Which is somewhat the same end results.
No idea on the impacts it can cause in your system tho.
October 19, 2011 at 11:25 am
I know I did. Just not sure if it was this exact version :-D.
October 19, 2011 at 11:24 am
PS you can also simply make a new install for ssrs 2K8 R2 and use the old 2K5 engine. You don't need to upgrade the whole thing.
October 19, 2011 at 10:54 am
Use the Upgrade advisor to see if you possibly have troubles.
Deprecated features : http://msdn.microsoft.com/en-us/library/ms143729.aspx
October 19, 2011 at 10:54 am
GilaMonster (10/19/2011)
Ninja's_RGR'us (10/19/2011)
mbender (10/19/2011)
that stinks, but thanks for all you help very informative as usual
It's back online now. So hopefullly no more than 1-2 millions users got shut out...
October 19, 2011 at 10:53 am
Ninja's_RGR'us (10/19/2011)
SQLRNNR (10/19/2011)
Run the scripts for parts I and II from this article and let us know which script it correlates to in your server (of the two you mentioned)
Still...
October 19, 2011 at 10:51 am
mbender (10/19/2011)
that stinks, but thanks for all you help very informative as usual
It's back online now. So hopefullly no more than 1-2 millions users got shut out ;-).
October 19, 2011 at 10:44 am
SQLRNNR (10/19/2011)
Run the scripts for parts I and II from this article and let us know which script it correlates to in your server (of the two you mentioned)
Still fails...
October 19, 2011 at 10:43 am
george sibbald (10/19/2011)
Views occupy no space, they are just queries.
heres a couple of queries to...
October 19, 2011 at 10:35 am
Run the code found here and post the results => http://sqlskills.com/BLOGS/PAUL/post/Survey-nonclustered-index-counts-(code-to-run).aspx
Who was working during the weekend and what where they doing?
17 GB just doesn't happen overnight.
October 19, 2011 at 10:29 am
Viewing 15 posts - 1,861 through 1,875 (of 18,926 total)