The Difference between Truncate and Delete in SQL Server
This article explains the differences between the Truncate and Delete commands in SQL Server.
2019-09-18 (first published: 2007-11-22)
35,993 reads
Prashant Pandey
SQL – Backup Methods, Some Cool Scripts
This article will tell you about some ways of taking all databases backup using one single command.
2008-11-07
13,598 reads
2008-01-16
18,353 reads
Blogs
Errata for my book: Pro Encryption in SQL Server 2022
My biggest fear when my book went into production was that any factual errors...
SQL Server Quickie #45 – SQL Server Availability Groups
Today I have uploaded SQL Server Quickie #45 to YouTube. This time I’m talking...
Daily Coping 21 Mar 2023
By Steve Jones
Today’s coping tip is to listen to a piece of music without doing anything...
Forums
Fixing a mismatched collation on MSDB
Hi, I've been tasked with finding out why we've been unable to patch the...
How to download from a dynamic link using SSIS?
Hi everyone, So I have a ssis package in which I download a excel...
Ask SSC