Building calendar table using MTVF
This script is a small extension to this excellent article
http://www.sqlservercentral.com/articles/calendar/145206/
2017-03-28 (first published: 2017-02-21)
1,417 reads
Scripts
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)
802 reads
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,426 reads
2017-03-21 (first published: 2017-03-15)
484 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,179 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,521 reads
2017-03-08 (first published: 2017-02-16)
2,001 reads
2017-03-07 (first published: 2017-03-01)
1,249 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)
517 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,345 reads
Blogs
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Audit – Security Compliance Frameworks (Part 1)
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Forums
Alamat Kontak Bank BCA KCP Cimahi Telp:08218154392
WA CS:08218154392 Jl. Raya Cimahi No.533, Karangmekar, Kec. Cimahi Tengah, Kota Cimahi, Jawa Barat...
Alamat Kontak Bank BCA KCU DAGO Telp:08218154392
WA CS:08218154392 Jl. Ir. H. Juanda No.118, Lebakgede, Kecamatan Coblong, Kota Bandung, Jawa Barat...
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened
Comments posted to this topic are about the item Can You Really Downgrade from...
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers