SQL Server Undocumented Commands

Finding a transaction in the log for a particular user

Posted on: June 3, 2015 11:45 am

More on using Transaction SID from the transaction log

Posted on: February 11, 2014 6:54 am

Real world story of DBCC PAGE saving the day

Posted on: September 19, 2013 1:20 pm

How to tell who changed a log file characteristic?

Posted on: September 18, 2013 2:10 pm

Tracking page splits using the transaction log

Posted on: February 7, 2013 11:43 am

DBCC WRITEPAGE: an introduction

Posted on: February 5, 2013 11:45 am

Parent transaction ID in 2012 fn_dblog output

Posted on: October 4, 2012 9:15 pm

Why are so many DBCC commands undocumented?

Posted on: June 5, 2012 5:31 am

Using fn_dblog, fn_dump_dblog, and restoring with STOPBEFOREMARK to an LSN

Posted on: May 17, 2012 3:05 am

New script: When were the sp_configure options last changed?

Posted on: April 26, 2012 11:30 am

Disaster recovery 101: hack-attach a damaged database

Posted on: June 18, 2010 12:11 pm

CHECKDB From Every Angle: How to tell if data purity checks will be run?

Posted on: August 19, 2009 11:04 am

Finding out who dropped a table using the transaction log

Posted on: June 16, 2009 6:27 pm

Investigating locking and deadlocking with %%lockres%%

Posted on: May 30, 2009 3:41 pm

Ghost cleanup redux

Posted on: March 19, 2009 10:44 am

FILESTREAM directory structure – where do the GUIDs come from?

Posted on: March 17, 2009 4:19 pm

TechEd: 80 minute video of Corruption Survival Techniques presentation

Posted on: December 5, 2008 6:14 am

Conference corruption demo scripts and example corrupt databases

Posted on: November 24, 2008 11:27 am

Search Engine Q&A #21: File header pages, and file header corruption

Posted on: July 25, 2008 2:10 pm

Search Engine Q&A #20: Boot pages, and boot page corruption

Posted on: July 11, 2008 12:01 am

CHECKDB From Every Angle: Using DBCC PAGE to find what repair will delete

Posted on: June 9, 2008 3:54 pm

New script: How much of the database has changed since the last full backup?

Posted on: April 8, 2008 4:49 pm

SQL Server 2008: New (undocumented) physical row locator function

Posted on: March 20, 2008 12:25 am

Inside The Storage Engine: sp_AllocationMetadata

Posted on: March 12, 2008 10:38 pm

Inside the Storage Engine: Ghost cleanup in depth

Posted on: October 8, 2007 4:24 pm

Search Engine Q&A #6: Using fn_dblog to tell if a transaction is contained in a backup

Posted on: October 6, 2007 1:00 am

Inside the Storage Engine: Proof that records are not always physically stored in index key order

Posted on: October 4, 2007 3:29 pm

Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back

Posted on: October 1, 2007 1:53 am