Browse the archive
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 …
Continue readingStatistics 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.
Continue readingQuestion We have a 3TB OLTP database running Siemens Opcenter MES software at one of our manufacturing plants in China. This is setup in an Always-On Availability group with one secondary node. As this is a manufacturing plant, we are only provided 11 1/2 …
Continue readingQuery SERVERPROPERTY() and DATABASEPROPERTYEX() from a view without relying on undocumented tricks.
Continue readingQuestion That's a weird scenario. The transaction log is full. It waits on AG. AG is all good. No latency, last commit/hardened time is almost real-time on all the nodes. The Estimated Recovery Time is zero. I checked this from the primary node and …
Continue readingFor this month's T-SQL Tuesday, John McCormack (blog) asks us: “What are your go-to short, handy scripts”? I've got so many handy dandy scripts, it was hard to choose. Where to start? I have so many go-to scripts that are short, amazing, and I use all the …
Continue readingHow Australian daylight saving time affects time zone conversions in SQL Server and why the offset can surprise you.
Continue readingReplace sp_hexadecimal and sp_help_revlogin with a more maintainable way to script SQL Server logins.
Continue readingUse OBJECT_NAME() to resolve object IDs in SQL Server blocking diagnostics and identify the affected objects.
Continue readingYesterday, I talked about batching deletes, and the day before I talked about how much I like to delete data, and why it's necessary to do it, despite being a data pack rat. Today, let's look at just one scenario, and how I like to handle it. In my experience, …
Continue reading
