Viewing 15 posts - 76 through 90 (of 129 total)
george sibbald (6/23/2011)
The same way I presume you set it to 90, rebuild all indexes specifying a fill factor of 0.
When you rebuild indexes through the maint. plan GUI, there...
June 23, 2011 at 5:42 pm
Grant Fritchey (6/11/2011)
June 13, 2011 at 9:01 am
GilaMonster (6/10/2011)
Save the file as a .sqlplan and attach it.
Sorry, didn't see the attachment option initially. The plan is attached.
June 13, 2011 at 8:54 am
I was considering reordering the columns in the index - didn't realize that I was in the SQL 2000 area - did a 'find' on 'perf tuning' within the page.
This...
June 10, 2011 at 3:02 pm
Well, the exec plan recommended the index. The columns recommended are the exact fields referenced in the "where" criteria of the poorly performing query.
After re-running the plan, it's recommending...
June 10, 2011 at 1:06 pm
Lowell (6/1/2011)
if not too much time has past, the default trace, which logs DDL events like CREATE ALTER DROP, might still have it:
Thanks Lowell, that was the ticket! FYI...
June 1, 2011 at 2:37 pm
Greg Swanson (6/1/2011)
FYI: There is a VMWare issue that is associated with getting this error having to do with using the Paravirtual SCSI drivers. See the following KB:Greg
Not...
June 1, 2011 at 11:53 am
Ninja's_RGR'us (5/25/2011)
Suspension with no pay agreeed by HR might...
May 25, 2011 at 9:55 am
Shawn Melton (5/25/2011)
Found this over on StackOverflow.com that might work and lead you to a solution.
I think I can work with this. Thanks!
May 25, 2011 at 9:51 am
Sean Lange (5/16/2011)
May 16, 2011 at 8:37 am
Sean Lange (5/16/2011)
Not sure I understand how dividing by 100 is rounding. All that does is move the decimal place two places to the left.
To use the div/100, I must...
May 16, 2011 at 8:32 am
That works, but unfortunately the data is for accounting - So rounding is not an option.
Any other ideas?
May 16, 2011 at 8:15 am
My dept. is over budget at the moment, so I have to work with what I have for now.
Would like to get a feel for how often SQL...
May 7, 2011 at 12:30 pm
PaulB-TheOneAndOnly (5/6/2011)
Also,...
May 7, 2011 at 11:51 am
After putting some thought into it. I can create a test db, restore it from my full backup, diff, and transaction log backups. Once I validate the data/restore,...
May 5, 2011 at 7:50 pm
Viewing 15 posts - 76 through 90 (of 129 total)