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,017 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
636 reads
Recently I was looking through DBA.StackExchange when I saw a pretty simple question that...
By Steve Jones
Today’s coping tip is to write down three things you appreciate about yourself. I...
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...
I know there are lambda versions. But I want to know if this can...
Hi. Publisher stop sending transaction to AOAG primary replica whenever AG failover. It seems...
I'm in the process of replacing a sql server 2012 with 2019. How do...
Ask SSC