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,304 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,841 reads
One of the nice things about the Microsoft Connector for Oracle is that it...
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
I've noticed in one of our applications a cursor uses operation 40 and that...
Ok, need someone to talk me off the cursor ledge on this one. I...
Ask SSC