One of the tasks of administrator is to estimate size of the database. But how to do this? As input for the task dba can receive: structure of the database and estimated number of records in each database. Generally this should be enough...
Having structure of objects in the database, objects like procedures, functions, views can be ommitted in estimation. Those objects don't contain data, so they are small. No worries.
What is important are tables and indexes. But no worries again, as Sybase dba has very useful procedure sp_estspace!
Let's suppose a database contains table of following structure:
CREATE TABLE Document (ID INT IDENTITY PRIMARY KEY CLUSTERED, NAME VARCHAR(50) NOT NULL, DESCRIPTION VARCHAR(200) NULL, DATE DATETIME DEFAULT GETDATE())
Additionally following index has been created:
