Viewing 15 posts - 1,981 through 1,995 (of 18,926 total)
Lynn Pettis (10/17/2011)
Export to a tab delimited file and import that to Excel.
Does that import in the correct format? Does it keep calculated columns on the report or that...
October 17, 2011 at 4:19 pm
Brandie Tarvin (10/17/2011)
Ninja's_RGR'us (10/17/2011)
In this particular case, the query optimizer couldn't really figure out what I wanted.
All right. It's time to complain. Grab your pitchforks, torches, tar and feathers. We're...
October 17, 2011 at 11:01 am
I guess you apply scripts to run this... just save those somewhere so you can rerun them.
Plan be would be scripting the whole db or use red-gate diff tools. ...
October 17, 2011 at 10:49 am
aurato (10/17/2011)
October 17, 2011 at 10:47 am
SQL Kiwi (10/17/2011)
Ninja's_RGR'us (10/17/2011)
Care to guess by how much is the estimate...
October 17, 2011 at 10:45 am
aurato (10/17/2011)
Any idea if it's safe to delete rows from distribution.dbo.msrepl_commands? I know the two rows I need to oust.
I never played there. But assuming the constraint...
October 17, 2011 at 10:34 am
Is the index/constraint enabled?
October 17, 2011 at 10:24 am
Seems to be the issue of the day that estimated vs actual # of rows don't match.
Care to guess by how much is the estimate off? ...
October 17, 2011 at 9:52 am
pwalter83 (10/17/2011)
Ninja's_RGR'us (10/17/2011)
Well I'm out of ideas them. You know all I know about this problem and all the ways to treat the issue.Issue resolved
So what was the solution?
October 17, 2011 at 9:41 am
Steve Jones - SSC Editor (10/17/2011)
I recommend you not back up multiple backups to one file. It's a risk that's unnecessary and any problem...
October 17, 2011 at 8:54 am
Well I'm out of ideas them. You know all I know about this problem and all the ways to treat the issue.
October 17, 2011 at 8:15 am
Easy way to test is to put it out there and come back later to see the real cost. Keep in mind that most systems I tune are severly overpowered...
October 17, 2011 at 8:00 am
pwalter83 (10/17/2011)
Ninja's_RGR'us (10/17/2011)
Start a new trace and start the standard (default) trace.
Depending on how SSRS plays here you might see something like SP_EXECUTESQL ... 'EXEC...
October 17, 2011 at 7:58 am
I'd be most happy to be proven wrong... 😉
October 17, 2011 at 7:52 am
ruan.keyser (10/17/2011)
Thanks a lot.I will review a bit!
Regards
Fair warning. That article assumes you can do basic tuning. That part we can't give away. It's acquired by 1000s...
October 17, 2011 at 7:39 am
Viewing 15 posts - 1,981 through 1,995 (of 18,926 total)