Data Compression Double Take
A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.
2012-03-05
267,356 reads
A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.
2012-03-05
267,356 reads
A lot has been written about the potential performance benefits of SQL Server data compression; but hard performance data? Not so much.
2012-03-01
333 reads
Databases are unique in IT that they are singularly resistant to 'best practice' advice. Any such advice can never be anything other than a starting position for tests in your own environment.
2012-01-23
61 reads
Tony Davis reflects on the existential angst felt by the DBA separated from his or her hardware.
2011-12-19
107 reads
There's more information hidden behind those graphical plans than you might first suspect.
2011-10-31
218 reads
Whereas there are plenty of experts prepared to help with the technology, few seem to come forward when the struggle is against the bureaucracy rather than a recalcitrant server. Where are all the SQL MVBs (Masters at Vanquishing Bureaucracy) when you need them!?
2011-09-26
132 reads
In order to gain better support for learning and training opportunities, the DBA needs to prove a direct link to productivity and results, in words and numbers the CEO will understand.
2011-07-18
256 reads
I'd like to hear the thoughts of DBAs out there on Windows and SQL Azure, and the prospects of moving applications and databases into the clouds. How many DBAs work for companies that have done it or are seriously considering it? What are the deepest concerns?
2011-07-04
86 reads
Any DBA who has been bitten by these subtle data integrity issues, or reports that erratically produce the wrong results, will know how much careful testing is involved in mitigating them.
2011-04-04
268 reads
For many, there is something disconcerting in the idea of the Query Optimizer; they crave control, but it really is best to take a back seat and let the Optimizer do its job.
2011-02-07
193 reads
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
We have created a parent table, child table & Audit log table in SQL...
Comments posted to this topic are about the item Change Tracking Default Retention
I am trying to create a subscription that posts to a one drive directory. ...
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers