This new approximate function may not cut down on execution time, but it relieves a whole lot of memory pressure.
I share my slides and demos from sessions at SQLintersection in Las Vegas.
Microsoft has pulled several patches for older versions of SQL Server. If you need TLS 1.2 support on an unsupported version, your recourse is to contact Microsoft support.
Some of your gnarly scalar UDFs will stop being in the naughty book when they can be inlined.
Some additional details about this sp_MSforeachdb (and sp_foreachdb) replacement.
New first class citizen in SQL Server 2019 that will help you identify and audit sensitive information.
This new function eliminates some of the tedious legwork you might find yourself doing with DBCC PAGE.
I talk about the top 10 wait types observed among SentryOne customers, and where to turn when you experience one of them on your own system.
This replacement for sp_foreachdb makes even more improvements over the original system procedure, sp_MSforeachdb.
I show that, in some cases, INSTEAD OF triggers can be better for performance than AFTER triggers.
In this post, see what it took to migrate nearly 5,000 posts from the SQLPerformance.com Q&A site on AnswerHub to WordPress.
I talk about the pros and cons of letting SQL Server wait to get a more accurate cardinality estimate from a table variable.
I discuss a queue table for DDL notifications instead of handling them within a DDL trigger.
Updated for a more modern version, I explain how to install and use SQLLocalDB.
This tip was refreshed with status updates for some of the critical bugs discovered in MERGE over the years.
SQL Server will gladly tell you about missing indexes, but it may not give you the keys in the right order.
For this T-SQL Tuesday, I talk about my methods for metadata discovery in new versions of SQL Server.
GDPR is a big deal for a lot of us; in this tip I explain how you might want to deal with "forget me" requests.
I show how to denormalize data using FOR XML PATH and STRING_AGG, and explain which one is faster.
Privacy laws are going to make us all much more careful about how we handle data archival and purge processes.
I show how to enable, disable, drop, and re-create all triggers in a database using dynamic SQL.