Category Archives for "SQL Server"

Aug 29

Backup and Restore Databases with CHECKSUM and VERIFYONLY

By Lori Brown | Backup and Restore , SQL Administration , SQL Maintenance , SQL Server

I found out that I have been missing something from our regular database backups that I had no idea that I should have been using all along.  I know about verifying your backup file and have incorporated into our standard maintenance routines one that will periodically test backups by restoring using VERIFYONLY.  However, I totally […]

Continue reading
Mar 07

Should I Replace My FOR XML PATH String Merges with String_agg?

By Jeffry Schwartz | Function , Performance Tuning , Query Tuning , SQL Development , SQL Server

Overview If you are looking for major performance gains, the answer is no.  However, if you are using SQL Server 2017 and developing new code, you should consider using the new String_agg function that is available on SQL Server 2017 because code that uses this function is so much more readable and easier to write […]

Continue reading
1 2 3 20
>