With high transactions table the sys.syscommittab table does not gets deleted properly. Millions of backdated row remains. To delete the sys.syscommittab table below is the script.
2017-11-13 (first published: 2017-10-27)
924 reads
SQL Server procedure to script all tables in a given database to one or individual files on a given path.
2017-10-09 (first published: 2017-10-04)
3,028 reads
2017-10-05 (first published: 2017-10-02)
16,716 reads
Lists the job names and package names for jobs that execute SSIS packages (for packages stored in msdb).
2017-09-13 (first published: 2017-09-05)
2,094 reads
Some short & sweet PS code to add databases on AG Node 1 to AG Node2 and snap them in.
2017-09-12 (first published: 2017-09-07)
1,007 reads
Stored procedure to ensure CDC job will be started once failover happen.
2017-08-25 (first published: 2017-08-22)
826 reads
This script will give you a thorough report about sql server jobs based on historical data.
2017-07-26 (first published: 2013-09-25)
2,193 reads
Script database and object level permissions for all database users
2017-07-25 (first published: 2016-02-26)
15,565 reads
2017-07-24 (first published: 2017-07-12)
642 reads
This is a simple powershell script that will add a particular login to multiple SQL Server instances in a go.
2017-07-19 (first published: 2017-07-04)
1,961 reads
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
Comments posted to this topic are about the item Hyperscale Replicas II
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Comments posted to this topic are about the item Your Favorite Quotes
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers