Amit Jethva

  • Interests: Web surfing, scripting, watching cricket

Technical Article

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,895 reads

Blogs

Daily Coping 21 Jan 2021

By

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

Using dbachecks for CIS Security Checks

By

Well back at the end of 2019 I finished writing most of the checks...

How to tell if Change Data Capture (CDC) is working as expected

By

I’m not sure how many of you use Change Data Capture (CDC) on your...

Read the latest Blogs

Forums

List of all the Users who have Access to Schema of a Particular Database.

By satnam.singh 44358

This Question is for an Azure PaaS Database. Does anybody has a Good Script...

Restore is not progressing at all . Please kindly help

By WhiteLotus

Hi All , I need to restore database 1.2 TB .. bak files are...

Server Consolidation

By mtz676

Hello All, Our entire domain is on VM.The CPU's usage rarely goes above 20%.Is...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers