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)

You rated this post out of 5. Change rating

2004-08-11 (first published: )

2,914 reads

SQLServerCentral Article

Capturing The Error Description In A Stored Procedure

Error handling is one of those things that is simple to do in SQL Server, but most people don't do it and it's not the most rebust thing. Here's another way that you can implement error handling in your stored procedures from a new author Amit Jethva.

4.67 (3)

You rated this post out of 5. Change rating

2004-04-27

21,097 reads

Technical Article

Monthly SQL Server Agent Jobs report

Monthly SQL Server Agent Jobs report Script               Monthly SQL Server Agent Jobs report. It will give a summarized picture of SQL Agent jobs run during a calendar month. You can use it to file up reports for system audit. It does not handle jobs that are run more than […]

4.5 (4)

You rated this post out of 5. Change rating

2003-12-30

1,370 reads

Blogs

Announcing a New Book on SQL from 3Cloud Authors

By

I am proud to announce the launch of a new book, centered around the...

Identify the (Top 20) most expensive queries across your SQL Server using Query Store

By

Script to identify the most expensive queries on your database server using the Query...

Setting Up Always Encrypted

By

In this post we're going to go through the steps to set up Always...

Read the latest Blogs

Forums

TOP with Order By alternative, performance results look mixed

By MMartin1

Hi I have a situation where I am testing two versions of the same...

Upgrading an Always on Availability Group two node from SQLServer 2016 to 2019

By ericwenger1

I'm looking for best practice here and these are Azure VMs by the way....

Azure availability groups requirements question

By Brandie Tarvin

Does anyone know if Azure absolutely requires windows clustered services to support availability groups?...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers