Qian Ye


Differential Backup Tricks

Differential backups are left out of many DBAs backup strategy, but they are a great tool to shrink your backup window, save disk space, and more. However they can be slightly tricky when you look to perform a restore. New author Qian Ye brings us an interesting issue that occured during differential testing.

3.5 (4)

2006-06-14

8,262 reads

Blogs

Goal Progress–Feb 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

How to: exec sp_help on temp tables?

By

Say you have a temp table and you want to see the columns names. For...

Daily Coping 26 Feb 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Better query to get count based on column value

By IT researcher

I am using SQL server 2008 R2 express edition. Out of below 3 method...

Why are DBAs not paid for knowledge and other IT Professionals are?

By Engineer

DBAs are being asked to know everything for 6 figures which cap out for...

Common Table Expression Misunderstandings

By Kathi Kellenberger

Comments posted to this topic are about the item Common Table Expression Misunderstandings

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers