Viewing 15 posts - 15,001 through 15,015 (of 49,552 total)
Since it's not usually a major issue, and can't be fixed while SQL's running, and it pretty immaterial on a SAN, not really.
But it you want. Google: file system fragmentation
It's...
January 3, 2013 at 7:33 am
Never heard the term 'data fragmentation'. Guess the person meant index fragmentation, because data can only be fragmented when it's in an index. (unless they meant data file fragmentation, which...
January 3, 2013 at 6:11 am
Restore from a good backup
And do some investigation of that IO subsystem, maybe move the DB elsewhere (different disks)
January 3, 2013 at 6:00 am
Post the output you got (everything). I can't tell anything from a description of the messages. (no, not with tablock)
Repair is not the recommended way to fix corruption, it's for...
January 3, 2013 at 12:56 am
kevin.kembel (1/2/2013)
January 2, 2013 at 4:38 pm
opc.three (1/2/2013)
GilaMonster (1/2/2013)
opc.three (1/2/2013)
Are you thinking of reorganize?
No.
I thought a rebuild would re-scan the clustered same as a drop+recreate which would work since all inconsistencies were found in the...
January 2, 2013 at 4:11 pm
DB_Newbie2007 (1/2/2013)
Full backups are done weekly and log backups daily.
Daily? So up to 24 hours of data loss is acceptable?
Log backups are usually a lot more frequent than that,...
January 2, 2013 at 3:46 pm
RAM-only table-variables are indeed a myth.
Table variables (like temp tables) will be in memory if possible and written to disk if not. They are always allocated space in TempDB, whether...
January 2, 2013 at 3:43 pm
CheckDB doesn't check the log file, so it wouldn't pick up the corruption.
Usual solution given for this case:
Restore a backup, full, and logs
Or, if you don't have backups (or can't...
January 2, 2013 at 11:44 am
opc.three (1/2/2013)
Are you thinking of reorganize?
No.
I thought a rebuild would re-scan the clustered same as a drop+recreate which would work since all inconsistencies were found in the nonclustered index.
Nope....
January 2, 2013 at 11:34 am
Read the article again.
If your log is continually growing it's because you're mis-managing it. Most likely full recovery model with no log backups. Read the article, make sure you have...
January 2, 2013 at 11:29 am
January 2, 2013 at 8:16 am
Don't rebuild the index. It'll likely fail. Drop the index and recreate it.
January 2, 2013 at 8:04 am
ChrisM@Work (1/2/2013)
May 2013 bring you excitement, enlightenment and all the rewards you deserve.
Why do I have to wait til May?
January 2, 2013 at 6:56 am
Restore from a clean backup, that's not repairable in any way.
January 2, 2013 at 6:27 am
Viewing 15 posts - 15,001 through 15,015 (of 49,552 total)