As a DBA, we are often tasked with maintenance work on the database. Often this includes making sure that old data is purged from the tables. This is especially true with logging tables. Sometimes multiple applications write to the same logging tables, and they can grow very quickly. Let’s say we have a logging table […]
2024-08-30 (first published: 2021-10-15)
25,389 reads
2021-10-08
2,244 reads
2017-04-25
249 reads
2017-04-12
6,958 reads
Audit your SQL logins to find passwords that have never been changed or that are very weak.
2017-04-04
4,333 reads
2017-03-21 (first published: 2017-03-15)
469 reads
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
3,407 reads
2017-03-07 (first published: 2017-03-01)
1,233 reads
2017-02-28
11,364 reads
2014-06-12
647 reads
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Hi, we put together an extract that runs every 15 minutes against what i...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Comments posted to this topic are about the item Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers