Contact  |  Site Map  |  Privacy      Call for more info
 
Latest code

DBA Library

Code generator - cursor loop over any table.
October 19, 2007

Every time I need to write a loop I tend to copy/paste it from somewhile. Just too boring to declare all variables (corresponding to column names), FETCH, @@FETCH_STATUS etc.

Code generator - exec any procedure
October 19, 2007

This is a simple stored procedure to generate a query for execution of any stored procedure.

Simple procedure to generate sample data.
October 12, 2007

This is a stored procedure that populates a specified table with random data. It s very useful in test environment, especially, for the performance tests.