Servers

    SQL Server DataSizer Tool

    Language:
    English
    The DataSizer spreadsheet is a tool that helps estimate the size of tables in SQL Server 7.0.
    • Details
      Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
      Version:

      1.0

      File Name:

      DataSizer.xls

      DataSizer.doc

      Date Published:

      8/3/2005

      File Size:

      16 KB

      41 KB

        The DataSizer spreadsheet is a tool that helps estimate the size of tables in SQL Server 7.0.

        It contains two worksheets, labeled Clustered and Heap. The Clustered sheet gives formulas to estimate the size of a clustered index table and its nonclustered indexes. The Heap sheet gives formulas to estimate the size of a heap table (any table that does not have a clustered index) and the associated nonclustered indexes.

        The formulas used in the spreadsheet are exact, but they are not complete (see “Not Covered by the Worksheets” next). Also, the worksheets include detailed information about the space used in each data and index row. You may not need that much detail and can go directly to the Table Size and NC Index Size totals after you have entered the data for your table.
    • Supported Operating System

      Windows 2000, Windows NT, Windows XP

        Microsoft Excel
        Microsoft Word
      • Download the .doc file for additional information and instructions.
        Download the .xls file and open it to use the tool.

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial