Home Forums SQL Server 2005 Administering How space is allocated for new objects in the data files? RE: How space is allocated for new objects in the data files?

  • The result of the code is as follows:

    116400140tempdevT:\MSSQL.1\MSSQL\DATA\tempdev.mdf

    316400134tempdev1T:\MSSQL.1\MSSQL\DATA\tempdb1.ndf

    416400123tempdev2T:\MSSQL.1\MSSQL\DATA\tempdb2.ndf

    516400119tempdev3T:\MSSQL.1\MSSQL\DATA\tempdb3.ndf

    616400134tempdev4T:\MSSQL.1\MSSQL\DATA\tempdb4.ndf

    716400126tempdev5T:\MSSQL.1\MSSQL\DATA\tempdb5.ndf

    816400115tempdev6T:\MSSQL.1\MSSQL\DATA\tempdb6.ndf

    916400125tempdev7T:\MSSQL.1\MSSQL\DATA\tempdb7.ndf

    1016400102tempdev8T:\MSSQL.1\MSSQL\DATA\tempdb8.ndf

    1116400119tempdev9T:\MSSQL.1\MSSQL\DATA\tempdb9.ndf

    1216400134tempdev10T:\MSSQL.1\MSSQL\DATA\tempdb10.ndf

    1316400119tempdev11T:\MSSQL.1\MSSQL\DATA\tempdb11.ndf

    1416400121tempdev12T:\MSSQL.1\MSSQL\DATA\tempdb12.ndf

    1516400112tempdev13T:\MSSQL.1\MSSQL\DATA\tempdb13.ndf

    1616400115tempdev14T:\MSSQL.1\MSSQL\DATA\tempdb14.ndf

    1716400107tempdev15T:\MSSQL.1\MSSQL\DATA\tempdb15.ndf

    -MJ
    Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.