Memory Corruptions, or Why You Need DBCC CHECKDB

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Paul Randal » Memory Corruptions, or Why You Need DBCC...

25 posts, Page 3 of 3

«««1 2 3

Memory Corruptions, or Why You Need DBCC CHECKDB

Rate Topic

Display Mode

Topic Options

Author

Message

Paul Randal

Posted Thursday, November 08, 2012 3:35 PM

SSCommitted

Group: General Forum Members
Last Login: Today @ 4:00 PM
Points: 1,910, Visits: 1,602

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

dharmendra.keshari

Posted Thursday, November 08, 2012 5:43 PM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 4:11 AM
Points: 2, Visits: 130

Thank you!!

Thanks
Dharmendra Keshari

Post #1382783

Jeff Moden

Posted Thursday, November 08, 2012 9:54 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:51 PM
Points: 32,923, Visits: 26,811

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."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1382811

Stuart Davies

Posted Friday, November 09, 2012 3:41 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 1:41 AM
Points: 2,477, Visits: 2,140

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

Neha05

Posted Monday, December 24, 2012 12:19 PM

SSC-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 »

25 posts, Page 3 of 3

«««1 2 3

Permissions