August 22, 2025 at 12:00 am
Comments posted to this topic are about the item Your Favorite Improvement
August 22, 2025 at 6:26 am
Like you, Window functions and CTEs changed the way I write a lot of my T-SQL. DROP … IF EXISTS also makes code much tidier.
When they made Developer Edition free was one of the 'this is a great idea' moments for me.
August 22, 2025 at 8:06 am
Windows functions / CTE: ease of querying
Extended events for finding specific occurences
Query Store: what queries are likely the culprit
SSRS / SSAS albeit getting outdated
Read committed snapshot isolation: similar like Oracle, reduces the locking problem when reports are running
August 22, 2025 at 3:12 pm
Compressed backups. I spent years supporting 80+ servers that couldn't store more than two days backups under happy conditions. Anything out of the ordinary would cause a page to the DBA on Call due to a low drive space condition on the backup drive. Wasn't uncommon to get multiple pages a night over the issue while on call. Backup compression (first via 3rd party, then native) changed that and did more to reduce our after hours support load than any other feature.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply