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

Blogs

Captioning Options for Your Online Conference

By

Many conferences have moved online this year due to the pandemic, and many attendees...

Virtual Log Files

By

Today’s post is a guest article from a friend of Dallas DBAs, writer, and...

Power BI – Hungry Median

By

Introduction Median is a useful statistical function, which first time appeared in SSAS 2016...

Read the latest Blogs

Forums

Variable Based on Variable in Paginated Report w/ Native Oracle Connection

By dataanalystanonymous

I have an SSRS paginated report where users need the ability to pick and...

IndicatorsPool events causing memory pressure?

By Ian (SSC)

Hi, We are running a system on SQLServer 2017 Enterprise (RTM-CU22) with 839GB of...

Sql Server Specs Question

By smattiko83

Hi, I have two different servers that I do a bulk insert on the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers