SQL Server 2000 has a rock solid backup scheme , but do you really need to run full backups every day? What if you could decide on the fly if it was more efficient for a full or a differential backup? Darwin Hatheway brings us the basis for a scheme that can predict the size of a differential backup by examining how much of the database has changed.
2006-03-13
7,417 reads
This article presents two best practices. One is about how to construct good table aliases, the other is about using ANSI join syntax. Good stuff!
2003-12-17
10,845 reads
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
By Steve Jones
Redgate Monitor has grown tremendously from its early days and I find many customers...
At work we have quite a few databases that I'm frequently browsing. This is...
So I backup & restore db as db_copy. within both there is a proc...
I want to transpose sql table rows to columns. I have written a query...
What are the restrictions for defaults on columns declared as sparse?
See possible answers