Date-based table purge
This procedure takes in charge the clean-up for a given table based on a date field
given as parameter and a retention expressed as a number of days.
2016-09-08 (first published: 2014-11-19)
1,509 reads
This procedure takes in charge the clean-up for a given table based on a date field
given as parameter and a retention expressed as a number of days.
2016-09-08 (first published: 2014-11-19)
1,509 reads
This script either generates or execute statements to SQL data and log files from C:\ to D:\
2015-07-01 (first published: 2015-06-03)
1,961 reads
A script that generates all the commands for installing a new database mirroring between two servers
2015-03-20 (first published: 2015-03-17)
937 reads
A script that generates all the commands for installing a new database mirroring between two servers
2015-03-17
157 reads
helps you manage dbWarden history.
No warranty given it will do what you expect, so test it !
2014-12-11 (first published: 2014-11-19)
998 reads
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Dipping my toes into the waters of Azure and of course before I get...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers