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,907 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,041 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,360 reads
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Monitoring for Problems The encryption of your existing data occurs as a background process...
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Please see my DDL. I would like to create: a) Dimensional table that tracks Primary...
I have a stored procedure that works across databases. So the "integration" database will...
Hi Team , Today i had an interview call. there was a question asked...
Ask SSC