2009-08-10
4,735 reads
2009-08-10
4,735 reads
This script automatically generates stored procedures for insert, update and delete operations on the given table
2009-08-12 (first published: 2009-07-23)
2,178 reads
Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table
2010-07-09 (first published: 2009-07-23)
35,697 reads
This code will drop all stored procedures made with splog. With minor modification it will also drop all functions and sp not made with splog.
2009-03-13 (first published: 2009-02-12)
1,032 reads
Search for a text in all the stored Procedures in a Database
2013-01-04 (first published: 2009-01-14)
3,682 reads
2010-09-10 (first published: 2008-11-17)
33,005 reads
2008-10-23
1,448 reads
Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.
2010-08-13 (first published: 2008-08-13)
61,181 reads
2008-07-17
345 reads
When searching meta-data to find an occurance of a particular string or pattern it is difficult to look everywhere. This procedure helps you find what you are looking for.
2008-05-28
8,739 reads
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Comments posted to this topic are about the item The Improvement Limit
Comments posted to this topic are about the item Migrate SSRS Reports to a...