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 […]
2004-08-11 (first published: 2004-02-16)
2,904 reads
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.
2004-04-27
21,000 reads
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 […]
2003-12-30
1,351 reads
By Steve Jones
I was reminded this week that I needed to get registered for the Data...
By Steve Jones
Today’s coping tip is to choose to see your mistakes as steps to help...
By gbargsley
Good day reader. This post is coming to you from a busy week in...
We have change tracking enabled on one of our databases and I am looking...
I have two databases on the same server. I have a service account I...
Hi, I'm trying to run the below SQL code but I'm getting this error:...
Ask SSC