Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Memory Corruptions, or Why You Need DBCC CHECKDB Expand / Collapse
Author
Message
Posted Thursday, November 8, 2012 3:35 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, August 22, 2016 2:03 PM
Points: 2,053, Visits: 1,709
The vast majority is the I/O subsystem (software or hardware), small percentage is bad memory or other server issue, and small percentage is SQL Server software bugs.

Corruption can't be prevented, but you can prepare for it and work around it - through backups and redundant copies of the database.


Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Post #1382752
Posted Thursday, November 8, 2012 5:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 8, 2016 2:22 AM
Points: 4, Visits: 366
Thank you!!

Thanks
Dharmendra Keshari
Post #1382783
Posted Thursday, November 8, 2012 9:54 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 12:21 PM
Points: 41,233, Visits: 38,545
Paul Randal (11/8/2012)
Hey Jeff - nothing explicit, but that's going to be the topic of my next article for SSC that I'll be writing this month.


Outstanding, Paul! I very much look forward to that. Thanks for the heads up!


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

Helpful Links:
How to post code problems
How to post performance problems
Post #1382811
Posted Friday, November 9, 2012 3:41 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 12:29 AM
Points: 4,145, Visits: 4,308
Jeff Moden (11/8/2012)
Paul Randal (11/8/2012)
Hey Jeff - nothing explicit, but that's going to be the topic of my next article for SSC that I'll be writing this month.


Outstanding, Paul! I very much look forward to that. Thanks for the heads up!

With you Jeff - quite often I've seen articles on "how to find" and not as many on "what next"


-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1382921
Posted Monday, December 24, 2012 12:19 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, June 16, 2015 2:34 AM
Points: 424, Visits: 60
Nice article.
Post #1399962
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse