There are mainly two components. One job that is managing the full database backup - restore and a second job that manage the transaction log backup - restore. At this two a new one similar with the full database backup - restore can be added for the differential backups if is the case. I will […]
2005-02-15 (first published: 2004-04-01)
1,030 reads
It creates documentation for all user tables in a specific database. A server name/ database name was added on the top of the HTML file also a column datatype field was added to the HTML file. Now the @strHTML can have 8000 chars, before only 4000 - still for tables with a lot of columns […]
2003-10-27
649 reads
If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges,...
By DataOnWheels
https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the...
By Kevin3NF
We get it. There’s no budget for a DBA on staff, or even a...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
I manage a two-node production SQL cluster running SQL Server 2017 CU31 on Windows...
Hello SSC, I am not sure if I posted this in the right spot,...
What is a partial backup for a read-write database?
See possible answers