# mallon (blogs) — RSS Amplifier Recent posts from the 1 feeds in the RSS Amplifier directory that cover mallon. Page: Feed: --- ## [Consuming SQL Agent dates & durations](https://am2.co/2025/03/consuming-sql-agent-dates-durations/?utm_source=rss&utm_medium=rss&utm_campaign=consuming-sql-agent-dates-durations) _2025-03-07 · Andy · Andy M Mallon – AM²_ SQL Agent s schema is older than me. It handles dates, times, and durations like it s 1980 by using integers instead of date/time data types. My buddy Aaron Bertrand talks more about Dating Responsibly so that you can have a good datetime with your own database. ... \[Read More\] The post Consuming SQL Agent dates durations appeared first on Andy M Mallon - AM² . ## [Migrating my Stack Overflow answers to blog posts (Sorry for the spam)](https://am2.co/2024/11/migrating-my-stack-overflow-answers-to-blog-posts-sorry-for-the-spam/?utm_source=rss&utm_medium=rss&utm_campaign=migrating-my-stack-overflow-answers-to-blog-posts-sorry-for-the-spam) _2024-11-11 · Andy · Andy M Mallon – AM²_ For a while, I have been thinking about using my Stack Overflow answers (and answers on other sites on the Stack Exchange Network), and storing a copy of them here, on my blog as well. All posts on the Stack Exchange network are covered under ... \[Read More\] The post Migrating my Stack Overflow answers to blog posts (Sorry for the spam) appeared first on Andy M Mallon - AM² . ## [Not all stats should be auto-updated](https://am2.co/2024/08/not-all-stats-should-be-auto-updated/?utm_source=rss&utm_medium=rss&utm_campaign=not-all-stats-should-be-auto-updated) _2024-08-29 · Andy · Andy M Mallon – AM²_ Statistics auto-updates are generally a good thing auto-update of statistics is the default behavior in SQL Server. Having the freshest information about the data shape helps to inform the best selection of an execution plan for queries. Except for when it doesn t. Because It Depends™️ Let s ... \[Read More\] The post Not all stats should be auto-updated appeared first on Andy M Mallon - AM² .