Viewing 15 posts - 11,731 through 11,745 (of 49,552 total)
If the clustered index name is null, then that's a heap, a table without a clustered index.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2013 at 7:31 am
Paul Randal is doing a couple of corruption courses for Pluralsight.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2013 at 7:06 am
Something has written zeros over a largish portion of your database file. That's not 'OK'. Doesn't have to be the disks, anything in the IO subsystem.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2013 at 3:47 am
Yes, you've got some problems with your IO subsystem that's caused major, widespread corruption in your database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2013 at 3:41 am
Restore from a clean backup (one taken before the corruption occurred).
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2013 at 3:28 am
They have the type 'S' in sys.objects?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2013 at 11:55 am
I'm done with MS certs. From what's been said (which I cannot repeat), I'm not at all optimistic about their plans.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2013 at 11:43 am
GilaMonster (8/26/2013)
Please run the following and post the full and complete, unedited output.
DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2013 at 11:41 am
azenon (9/9/2013)
My ultimate goal is to stop the file from growing any larger and speed up the nightly backups....
Neither of those will be achieved by shrinking the file.
A file won't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2013 at 11:23 am
No, you cannot create indexes on system tables. Are the CDC tables system tables though?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2013 at 11:18 am
If you want to pay them, sure.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2013 at 11:16 am
Doesn't when I test. It does however throw
Msg 16924, Level 16, State 1, Line 69
Cursorfetch: The number of variables declared in the INTO list must match that of selected...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2013 at 7:35 am
Running CheckDB on a restored backup is fine. However, monthly is maybe not fine. Do you retain all your backups for a full month? If not, what are you going...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2013 at 7:18 am
MyDoggieJessie (9/9/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2013 at 7:14 am
And the error reads..... ?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2013 at 7:11 am
Viewing 15 posts - 11,731 through 11,745 (of 49,552 total)