Welcome to MSDN Blogs Sign in | Join | Help

Benjamin Wright-Jones

SQL Server Lessons Learned and Notes from the Field (Microsoft Consultancy Services, UK)

News

  • This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified on Microsoft.com Locations of visitors to this page
Finding the NTFS Sector Size via DBCC

You can determine the formatted sector size of the database using DBCC FILEHEADER ('<dbname>').  The DBCC command actually returns quite a lot of information but we are only interested in the sector size column.  

Posted: Tuesday, October 31, 2006 7:29 PM by benjones
Anonymous comments are disabled
Page view tracker