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,915 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,159 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,376 reads

Blogs

Executing One Line in VSCode–#SQLNewBlogger

By

I wrote about arrays in PowerShell last week, but I realized one of the...

Friday Flyway Tips–Comparison Options

By

Recently a customer asked how they could get index changes to be captured in...

A New Word: Guiltwrights

By

giltwrights  – n. the imaginary committee of elders that keeps a running log of...

Read the latest Blogs

Forums

Selecting from a view, base table has a DENY on a column

By pveilleux

This is something I've never seen before and I can't think of the right...

JSON data with Pivoted

By Tava

Hi All, I need some assistance and not sure how to achieve the expected...

SQL Window Functions Series: LAG() and LEAD()

By Nikhil Bangad

Comments posted to this topic are about the item SQL Window Functions Series: LAG()...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers