SQL Server DataSizer Tool
Brief Description
The DataSizer spreadsheet is a tool that helps estimate the size of tables in SQL Server 7.0.
On This Page
Quick Details
| Version: | 1.0 |
| Date Published: | 8/3/2005 |
| Language: | English |
| Download Size: | 16 KB - 57 |
| *Download size depends on selected download components. |
Overview
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.
Top of page
System Requirements
- Supported Operating Systems: Windows 2000; Windows NT; Windows XP
Microsoft Excel
Microsoft Word Top of page
Instructions
Download the .doc file for additional information and instructions.
Download the .xls file and open it to use the tool.
Top of page
Files in This Download
The links in this section correspond to separate files available in this download. Download the files most appropriate for you.
Top of page
Top of page
What Others Are Downloading
Top of page
