In this survey I’d like to know what your experience is using the DBCC WRITEPAGE undocumented command.
This survey is closed – see the editorial here – thanks!
I’ll editorialize the results in a week or two.
Thanks!
I’m excited to be presenting at the Pass Summit in November! My pre-con workshop is my absolute favorite to teach Performance Tuning with Waits and
Summer Sale time! Hundreds of dollars lower-than-ever prices on our signature 158-hour Blackbelt training bundle: Check It Out! SQLskills Complete Short Course Bundle $4,575.00 Original
(This post first appeared on SQLperformance.com four years ago as part of a blog series, before that website was mothballed later in 2022 and the
It’s quite common for a company that experiences a corruption-causing disaster, but has no valid backups to restore from and no ability to fail over
I thought it was bad previously, but in 2026 I’ve noticed a big rise in emails trying to scam me into clicking a link –
There are a huge number of best practices around SQL Server performance tuning – I could easily write a whole book on the topic, especially
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.
5 thoughts on “Survey: using DBCC WRITEPAGE”
None.
I’ve only used it to poke around and corrupt test databases in my own private lab. I’d never use this command outside of that.
Played with some of the techniques as you demonstrated in the SQL PASS 2013 pre-con.
Used this as an MCT, it was part of the piecemeal recovery lab for the instructor to corrupt the database. Never in a live environment (Test/QA/Prod).