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,504 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,504 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,920 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)
936 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)
988 reads
I posted on Terraform and Azure SQL last year but wanted to see what...
By Kevin3NF
As a SQL DBA, what do you do when a vendor application has performance...
A couple of days ago I was doing some cleaning on some Azure SQL...
Comments posted to this topic are about the item The On-Call Load
Comments posted to this topic are about the item Two Table Hints
Comments posted to this topic are about the item Database Dashboards in Azure Data...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers