Re: table size
From: BP Margolin (bpmargo@attglobal.net)
Date: 07/31/02
- Next message: BP Margolin: "Re: Viewing DTS package properties and Permissions"
- Previous message: Sue Hoegemeier: "Re: Viewing DTS package properties and Permissions"
- In reply to: kaushik: "table size"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "BP Margolin" <bpmargo@attglobal.net> Date: Tue, 30 Jul 2002 19:24:24 -0400
kaushik,
If the table already exists and is populated with data, then Andrew's
suggestion is definitely the way to go.
If the table does not exist, or is not fully populated, you might take a
look at the section "Estimating the Size of a Table" in the SQL Server Books
Online.
If you want to short-cut some of the calculations outlined in the Books
Online, consider getting hold of "Inside Microsoft SQL Server 2000" by Kalen
Delaney. The CD accompanying the book has a stored procedure that
encapsulates the formulas (and is actually a tiny bit more accurate) listed
in BOL.
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
"kaushik" <kaushikmondal@excite.com> wrote in message
news:2f4a01c237d2$451e51f0$3bef2ecf@TKMSFTNGXA10...
> what is the best way of calculating the size of a table
- Next message: BP Margolin: "Re: Viewing DTS package properties and Permissions"
- Previous message: Sue Hoegemeier: "Re: Viewing DTS package properties and Permissions"
- In reply to: kaushik: "table size"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
