Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Thursday, September 11, 2014 3:05 AM
Points: 2,039, Visits: 1,665
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: Tuesday, September 16, 2014 6:31 AM
Points: 2, Visits: 221
Thank you!!

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


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:52 AM
Points: 35,262, Visits: 31,744
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

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


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 8:36 AM
Points: 3,086, Visits: 3,322
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: Monday, April 15, 2013 11:42 PM
Points: 424, Visits: 55
Nice article.
Post #1399962
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse