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,435 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,847 reads
As AI continues to evolve, many of us are looking for ways to leverage...
By Steve Jones
I was chatting with a customer recently and they wanted to know which host...
Yeah, yeah, second AI post in a row. I promise not to make a...
Hi everyone I am looking at the size of my db on disk (ie...
Comments posted to this topic are about the item Getting the TEXTSIZE
Comments posted to this topic are about the item The Return to the Office...
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers