Post reply

Dbcc Page help

  • April 27, 2009 at 6:02 am

    #203882

    Hi all, there is anyway to find wich filenum, pagenum from certain information. Something like i have a table with id, name and adress. I want to know filenum and pagenum , to use in dbcc page, which corresponds a name 'Luis Roberto'... How can i find this ?

    Thanks a lot

    $hell your Experience !!![/url]

  • April 27, 2009 at 6:22 am

    #984286

    There's no easy way to find which page has a certain row on it. You can look with DBCC IND to see all pages allocated to a table, or in some of the system tables to see what is the root page and first page of the clustered index - from there you can navigate along the leaf-level to find the page you want. For an example script, see this blog post.

    Let me know if you have any more questions (I wrote DBCC PAGE for SQL 2005).

    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

  • April 27, 2009 at 6:27 am

    #984290

    Thanks a lot Paul,...

    $hell your Experience !!![/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply