There are many times when you might be concatenating text in a stored procedure to make a where clause, because the input parameters are optional. An alternative is to create many versions of the stored procedure - one for each possible combination of parameters - which can soon become too big. There is a more […]
2001-11-25
4,260 reads
When implementing a pilot study of audit trail triggers, you often want a way of removing all triggers in the database in order to retest your scripts: here it is!
2001-11-08
1,487 reads
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
By Brian Kelley
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...
Picture this, you’re happily backing up your database to a Azure blob storage until...
I'm having an issue trying to drop a service. When I issue the drop...
This is strange, any SQL job that sends out Emails via 'msdb.dbo.sp_send_dbmail ' are...
hi so i have a really old application that is used to process data...
Ask SSC