Amit Jethva

  • Interests: Web surfing, scripting, watching cricket

DATABASE / TABLE SIZE ESTIMATER

The code in this procedure takes standard formula’s given by Microsoft and calculates approximate size of a table as per the fields  & indexs on that table. The procdure can be quickly be used in a loop to work for entire database. Refer to article http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_92k3.asp for the actual document containing the formula’s used.There are […]

5 (1)

2004-08-11 (first published: )

2,887 reads

Blogs

Career: Talk To References

By

As we try to get through these strange times in the world, I am...

Daily Coping 14 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

WIT Mental Health and Wellness Videos Posted

By

I was honored to speak at the WIT Mental Health and Wellness day last...

Read the latest Blogs

Forums

unable to deploy package unable integration service catalog

By atulyan.aries

Hi I get teh following error while deploying package .NET Framework error occurred during...

Limit database restores to specific drive locations

By DrJogalog

As there isn't an option to use a DDL trigger on a RESTORE query,...

VLOOKUP Equivalent in SQL

By Sarah1997

Hi there I have two tables, one with an ID and Amount (Table 1)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Container Logs

See possible answers