Browse the archive
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 …
Continue readingQuestion I'm passing a JSON string to a stored procedure in order to insert warehouse inventory. Sometimes, there will be multiple line items with the same product, going to the same shelf, on the same pallet (LPN), with the same date. I would like to …
Continue readingI recently saw a question on DBA Stack Exchange (it has since been deleted by the author), who had a “special process” that ran regularly, and as part of that process, they disabled the trigger, did some stuff, and re-enabled it. During that process, the step …
Continue readingQuery SERVERPROPERTY() and DATABASEPROPERTYEX() from a view without relying on undocumented tricks.
Continue readingFor 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 all …
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 sys.dm_server_services to find SQL Server service accounts, startup times, and instant file initialization status.
Continue readingWe’ve all been there. You’ve got a query where the JOIN or WHERE predicate is not SARGable. You’ve read about how this can be a problem, and how bad it is for performance. Alas, you cannot change the query. Sometimes this reason is political, sometimes it’s …
Continue readingFix tempdb file sizing problems by bringing data files to consistent sizes and managing growth.
Continue reading
