Not all stats should be auto-updated

August 29, 2024 Andy 1

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]

T-SQL Tuesday: The last ticket I closed

February 13, 2024 Andy 2

For this month’s T-SQL Tuesday, Brent Ozar (blog|Instagram) asks us to describe the most recent ticket we closed. “We had a pretty significant wait spike…” The literal last ticket I closed was “please run this script in production…”, and I don’t think it would be … [Read More]

What’s the use case of disabling an index?

September 25, 2022 Andy 0

Question I just learned that indexes can be disabled on a table. Even the clustered index can be disabled. After that, users can’t access the index or the data if clustered index. When will we disable an index? I just don’t understand the use case. … [Read More]

A black dog sits outside on a blue bed. Her golden eyes are looking directly at the camera. She wears a rainbow kerchief around her neck, with the words "I bark at bigots" emblazoned on it

Publishing a Code of Conduct isn’t enough

July 13, 2022 Andy 1

I’ve seen more and more events & communities adopt Codes of Conduct. Even local events, local user groups, and smaller online communities are adopting Codes of Conduct. That’s GREAT! …but it’s just a great start. It’s not that easy. Discoverability The issue of discoverability is … [Read More]

Diagram of Batman's utility belt

T-SQL Tuesday #143: My favorite short scripts

October 12, 2021 Andy 2

For this month’s T-SQL Tuesday, John McCormack (blog|twitter) 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 … [Read More]

What time is it in Oz?

October 5, 2021 Andy 1

There was a recent post on Database Administrators, where there was some confusion over Daylight Saving Time(DST) in Australian timezones. Let’s be honest though–timezones are confusing, especially when DST comes into play. Arizona Time doesn’t observe Daylight Saving Time, so sometimes it’s the same as … [Read More]

Stop using sp_hexadecimal & sp_help_revlogin

July 6, 2021 Andy 2

Since I started at Stack Overflow, I’ve had the chance to see some of the interesting challenges with running our databases at our scale. My coworker Taryn Pratt (blog|twitter) recently blogged about fighting with deadlocks related to Stack Overflow for Teams. Lots of logins Taryn … [Read More]