Viewing 15 posts - 5,776 through 5,790 (of 18,926 total)
opc.three (5/25/2011)
Agreed, and it will be exacerbated due to the 100% fill factor.
The one case I had in mind the guy was still having problem at 40% fill factor, maybe...
May 25, 2011 at 11:06 am
If you change the job owner to youself do you still get the same error?
Did you change environements between the testing of the sp and conversion to job?
May 25, 2011 at 11:02 am
opc.three (5/25/2011)
...the next ID is provided by them and is always the next sequential number.
Who is "them" and what programming mechanism are...
May 25, 2011 at 10:45 am
Do you have another drive you can backup to?
Do you get the same error on the same drive / folder if you try to backup master or msdb?
May 25, 2011 at 10:44 am
WayneS (5/25/2011)
Ninja's_RGR'us (5/25/2011)
jshurak (5/25/2011)
nvm, i'm an idiot. I need some coffeeI think this means that he figured out the problem... like include all columns in the insert!
Or at least...
May 25, 2011 at 10:42 am
John Mitchell-245523 (5/25/2011)
In that case, I don't know what's happening. But I would look for that procedure SyncFunctions and see what it's trying to do.John
The only hint that makes...
May 25, 2011 at 10:13 am
SkyBox (5/25/2011)
Ninja's_RGR'us (5/25/2011)
Suspension with no pay agreeed by HR...
May 25, 2011 at 9:58 am
You talk about data corruption. Have your run checkdb? If so what are the errors (all of them >>> WITH NO_INFOMSGS, ALL_ERRORMSGS)
May 25, 2011 at 9:41 am
jshurak (5/25/2011)
nvm, i'm an idiot. I need some coffee
I think this means that he figured out the problem... like include all columns in the insert!
May 25, 2011 at 9:35 am
In the very slight chance you guys had considered that option. Have you tried uninstalling the files (or even hard delete)?
Suspension with no pay agreeed by HR might also...
May 25, 2011 at 9:34 am
Steve Jones - SSC Editor (5/25/2011)
I think that's a IE issue. I don't see that at all in Firefox. I'll have someone look at it
I'm on IE 8. It's...
May 25, 2011 at 9:20 am
Steve Jones - SSC Editor (5/25/2011)
I don't see anything weird there. Is there something I'm missing? Can someone post a screen shot.
had to do a video shot actually
May 25, 2011 at 8:39 am
srinath.vanama (5/25/2011)
Thanks for your reply,How can i test 1% of data, and moreover those three are non clustured indexes.
Can u help me with the code...
SELECT TOP 1 PERCENT * INTO...
May 25, 2011 at 8:29 am
Does you need to rework the clustered index as well?
Assuming the server and SAN are not busy doing something else, I'd figure out how much time it takes to write...
May 25, 2011 at 8:21 am
Update the stats on that table daily... maybe 1-2 hours before business hours start and that'll solve the issue.
May 25, 2011 at 7:23 am
Viewing 15 posts - 5,776 through 5,790 (of 18,926 total)