SQL Server Tacklebox- P43: This book, as with almost all books, started out as an idea. I wanted to accumulate together those scripts and tools that I have built over the years so that DBAs could sort through them and perhaps adapt them for their own circumstances. | 8 Finding data corruption Figure shows the output from rerunning dbcc page with this trace flag turned on. DBCC PAGE NEO 1 1 3 GO Messages 1 1 121 122 - ALLOCATED ALLOCATED _PCT_FULL 0 PCT FULL IAM Page Mixed Mixed Ext Ext 1 123 ALLOCATED 0 PCT FULL IAN Page Mixed Ext 1 124 ALLOCATED 0 PCT FULL Mixed Ext 1 125 ALLOCATED 0 PCT FULL IAM Page Mixed Ext 1 126 ALLOCATED 0 PCT FULL Mixed Ext 1 127 n ALLOCATED 0 PCT FULL IAN Page Mixed Ext 1 128 ALLOCATED 0 PCT FULL Mixed Ext 1 129 - 1 131 ALLOCATED 0 PCT FULL IAN Page Mixed Ext 1 132 - 1 136 ALLOCATED 0 PCT FULL Mixed Ext 1 137 ALLOCATED 0 PCT FULL IAN Page Mixed Ext 1 138 - 1 140 ALLOCATED 0 PCT FULL Mixed Ext 1 141 ALLOCATED 0 PCT FULL IAM Page Mixed Ext 1 142 - 1 143 ALLOCATED 0 PCT FULL Mixed Ext 1 144 - 1 149 ALLOCATED 0 PCT FULL 1 150 - 1 151 NOT ALLOCATED 0 PCT FULL Mixed Ext 1 152 - 1 153 ALLOCATED 0 PCT FULL Mixed Ext 1 154 ALLOCATED 0 PCT FULL IAM Page Mixed Ext 1 155 ALLOCATED 0 PCT FULL Mixed Ext 1 156 ALLOCATED 0 PCT FULL IAM Page Mixed Ext 1 157 ALLOCATED 0 PCT FULL Mixed Ext 1 158 ALLOCATED 0 PCT FULL IAN Page Mixed Ext 1 159 ALLOCATED 0 PCT FULL Mixed Ext 1 160 ALLOCATED 0 PCT FULL IAM Page Mixed Ext 1 161 ALLOCATED 0 PCT FULL Mixed Ext 1 162 ALLOCATED 0 PCT FULL IAM Page Mixed Ext 1 163 ALLOCATED 0 PCT FULL Mixed Ext 1 164 NOT ALLOCATED 0 PCT FULL Mixed Ext 1 165 ALLOCATED 0 PCT FULL IAM Page Mixed Ext 1 166 - 1 170 ALLOCATED 0 PCT FULL Mixed Ext 1 171 ALLOCATED 0 PCT FULL IAM Page Mixed Ext 1 172 - 1 383 NOT ALLOCATED 0_ PCT FULL DBCC execution completed. If DBCC printed error messages. contact your system administrator. Figure DBCC PAGE with trace flag 3604 turned on. At the bottom of the output I can see that pages 1 172 1 383 are not allocated and all pages are 0 full. Recall this is a database with no tables or any other objects created and with no data inserted. So let s now create a simple table and insert some data into it. The script to do this in is shown in Listing . It creates a .
