Stored Proc Archives rows to another table
This will Archive and Purge rows from one table to another.
2017-03-27 (first published: 2017-03-17)
742 reads
Scripts
PatReplace8K
This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.
2017-03-24 (first published: 2015-05-16)
2,355 reads
2017-03-21 (first published: 2017-03-15)
459 reads
Connect to MongoDB on Remote Linux Server with Powershell
Return values from MongoDB on Linux server with Powershell
2017-03-20 (first published: 2017-03-16)
1,131 reads
Find all published tables with row counts and table size
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
3,314 reads
2017-03-09 (first published: 2017-02-16)
1,923 reads
2017-03-07 (first published: 2017-03-01)
1,205 reads
Corrupt Page Notification
This trigger will send mail notification once a row is written in the suspect pages table
2017-03-03 (first published: 2017-02-21)
499 reads
Missing index with change impact percentage
This script will list all missing indexes with create statements.
2017-03-01 (first published: 2017-02-24)
1,316 reads
2017-02-28 (first published: 2015-06-22)
2,101 reads
Blogs
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
need help with assigning a value to a variable
Hi I am trying to assign the value of the variable using the output...
Merry Christmas 2025
Comments posted to this topic are about the item Merry Christmas 2025
The Reindeer Count
Comments posted to this topic are about the item The Reindeer Count
Question of the Day
The Reindeer Count
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers