object distibution in a mssql database?

• rene.schulz@implico.com

  Default port

  Points: 1400

  More actions

  February 16, 2011 at 2:06 am

  #232262

  Dear @all, I'm interested in to find out in what datafile of my database a table exists and how is the distibution of data blocks of this object. What commands I have to call? Many thx; René

• crazy4sql

  SSCoach

  Points: 19590

  More actions

  February 16, 2011 at 4:07 am

  #1287523

  Have a read of dbcc ind and dbcc page.

  You will get most of your answer.

  ----------
  Ashish

• rene.schulz@implico.com

  Default port

  Points: 1400

  More actions

  February 16, 2011 at 7:11 am

  #1287641

  thx a lot... all my qeustions are answared with this blogs

  http://www.mssqltips.com/tip.asp?tip=1578

  and

  http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/12/13/more-undocumented-fun_3a00_-dbcc-ind_2c00_-dbcc-page_2c00_-and-off_2d00_row-columns.aspx

  and last but not least

  http://msdn.microsoft.com/en-us/library/ms174397.aspx