2009-11-16
3,822 reads
Stored Procedures
2009-08-10
4,746 reads
Automatic Generation of Insert, Update and Delete stored procedures
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,197 reads
Dynamic creation of Insert, Update, Delete Stored procedures
Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table
2010-07-09 (first published: 2009-07-23)
35,753 reads
DROP all stored procedures
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,037 reads
Search All Stored Procedures in a Database
Search for a text in all the stored Procedures in a Database
2013-01-04 (first published: 2009-01-14)
3,688 reads
2010-09-10 (first published: 2008-11-17)
33,015 reads
2008-10-23
1,455 reads
Excel with Stored Procedures
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,300 reads
2008-07-17
354 reads
Blogs
Breaking Rules in Rome
By Steve Jones
Last week I was honored with a trip to Rome for the Redgate President’s...
Databases and AI Agents
By Arun Sirpal
As part of my wider work exploring Claude Code and AI-assisted database engineering, I...
Creating a Pulsing Conducting Baton - Part 1
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
Forums
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
What Can AI Really Do?
Comments posted to this topic are about the item What Can AI Really Do?
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers