Two temp tables walk into tempdb.
Standing room only. A window function is asleep on the floor. A table variable keeps telling everyone it has statistics. It does not.
T-SQL That Doesn't Suck: full day precon at #PASSDataSummit West.
passdatacommunitysummit.com/west/
Standing room only. A window function is asleep on the floor. A table variable keeps telling everyone it has statistics. It does not.
T-SQL That Doesn't Suck: full day precon at #PASSDataSummit West.
passdatacommunitysummit.com/west/
October 29, 2026 at 2:04 PM
Two temp tables walk into tempdb.
Standing room only. A window function is asleep on the floor. A table variable keeps telling everyone it has statistics. It does not.
T-SQL That Doesn't Suck: full day precon at #PASSDataSummit West.
passdatacommunitysummit.com/west/
Standing room only. A window function is asleep on the floor. A table variable keeps telling everyone it has statistics. It does not.
T-SQL That Doesn't Suck: full day precon at #PASSDataSummit West.
passdatacommunitysummit.com/west/
Why’s This Query So Slow in Prod? Check sp_BlitzPlanCompare.
You're testing a query, and you're just not getting the same performance between the development and production servers. There's a huge list of common things that might be causing it: Parameter sniffing Different database-level settings…
You're testing a query, and you're just not getting the same performance between the development and production servers. There's a huge list of common things that might be causing it: Parameter sniffing Different database-level settings…
Why’s This Query So Slow in Prod? Check sp_BlitzPlanCompare.
You're testing a query, and you're just not getting the same performance between the development and production servers. There's a huge list of common things that might be causing it: Parameter sniffing Different database-level settings like compatibility levels and cardinality estimators Different server-level settings like CTFP and MAXDOP Different hardware capabilities, like different numbers of cores available, memory grant sizes available, or TempDB speeds…
www.brentozar.com
October 21, 2026 at 1:15 PM
Why’s This Query So Slow in Prod? Check sp_BlitzPlanCompare.
You're testing a query, and you're just not getting the same performance between the development and production servers. There's a huge list of common things that might be causing it: Parameter sniffing Different database-level settings…
You're testing a query, and you're just not getting the same performance between the development and production servers. There's a huge list of common things that might be causing it: Parameter sniffing Different database-level settings…
My window function spilled to tempdb.
Tempdb was fine with it. Tempdb has seen things you people wouldn't believe.
Window functions that keep their memory grants to themselves: my #PASSDataSummit West precon.
passdatacommunitysummit.com/west/
Tempdb was fine with it. Tempdb has seen things you people wouldn't believe.
Window functions that keep their memory grants to themselves: my #PASSDataSummit West precon.
passdatacommunitysummit.com/west/
October 13, 2026 at 2:04 PM
My window function spilled to tempdb.
Tempdb was fine with it. Tempdb has seen things you people wouldn't believe.
Window functions that keep their memory grants to themselves: my #PASSDataSummit West precon.
passdatacommunitysummit.com/west/
Tempdb was fine with it. Tempdb has seen things you people wouldn't believe.
Window functions that keep their memory grants to themselves: my #PASSDataSummit West precon.
passdatacommunitysummit.com/west/
The latest release of PSBlitz brings:
- Microsoft Entra MFA support.
- Fixed session activity collection when tempdb CREATE TABLE perms are missing
- HTML report now flags non-default database-scoped configs
#PSBlitz #SQLServer #AzureSQL #MSSQL #DBA #PowerShell #OpenSource #MVPBuzz
- Microsoft Entra MFA support.
- Fixed session activity collection when tempdb CREATE TABLE perms are missing
- HTML report now flags non-default database-scoped configs
#PSBlitz #SQLServer #AzureSQL #MSSQL #DBA #PowerShell #OpenSource #MVPBuzz
GitHub - VladDBA/PSBlitz: a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and...
a PowerShell-based tool that outputs SQL Server health and performance diagnostics data to either Excel or HTML, and saves execution plans and deadlock graphs as .sqlplan and .xdl files. - VladDBA/...
github.com
October 9, 2026 at 12:41 PM
The latest release of PSBlitz brings:
- Microsoft Entra MFA support.
- Fixed session activity collection when tempdb CREATE TABLE perms are missing
- HTML report now flags non-default database-scoped configs
#PSBlitz #SQLServer #AzureSQL #MSSQL #DBA #PowerShell #OpenSource #MVPBuzz
- Microsoft Entra MFA support.
- Fixed session activity collection when tempdb CREATE TABLE perms are missing
- HTML report now flags non-default database-scoped configs
#PSBlitz #SQLServer #AzureSQL #MSSQL #DBA #PowerShell #OpenSource #MVPBuzz
SQL Server on Azure VM fails to deploy or come online. The article has been updated by Microsoft Learn with disclosed AI involvement (Sep, 2026).
#databases #Azure #SQLServer #IaaS #cloudcomputing #Troubleshooting
learn.microsoft.com/en-us/troubl...
#databases #Azure #SQLServer #IaaS #cloudcomputing #Troubleshooting
learn.microsoft.com/en-us/troubl...
Fix SQL Server on Azure VM Deployment and Startup Failures - SQL Server
Resolve SQL Server on Azure VM deployment and startup failures caused by unavailable ephemeral storage that prevents tempdb initialization.
learn.microsoft.com
October 6, 2026 at 4:09 AM
SQL Server on Azure VM fails to deploy or come online. The article has been updated by Microsoft Learn with disclosed AI involvement (Sep, 2026).
#databases #Azure #SQLServer #IaaS #cloudcomputing #Troubleshooting
learn.microsoft.com/en-us/troubl...
#databases #Azure #SQLServer #IaaS #cloudcomputing #Troubleshooting
learn.microsoft.com/en-us/troubl...
Skip().Take() works local, dies prod. EF Core nests ROW_NUMBER, blowing tempdb. Fix: Project DTOs + keyset pagination (WHERE id > lastId). Read your SQL. #dotnet #efcore
October 4, 2026 at 2:30 AM
Skip().Take() works local, dies prod. EF Core nests ROW_NUMBER, blowing tempdb. Fix: Project DTOs + keyset pagination (WHERE id > lastId). Read your SQL. #dotnet #efcore
Classic post: how to take any SQL Server down in less than 100 characters of T-SQL: www.brentozar.com/go/boom
SELECT*FROM GENERATE_SERIES(-9223372036854775807,9223372036854775808)ORDER BY 1DESC
SELECT*FROM GENERATE_SERIES(-9223372036854775807,9223372036854775808)ORDER BY 1DESC
Query Exercise Answer: Generating Big TempDB Spills - Brent Ozar Unlimited®
In last week’s Query Exercise, I challenged you to play some code golf to generate big spills with tiny T-SQL. Today, I’m going to walk you through my thought process – the initial attempts I tried…
www.brentozar.com
October 2, 2026 at 1:25 AM
Classic post: how to take any SQL Server down in less than 100 characters of T-SQL: www.brentozar.com/go/boom
SELECT*FROM GENERATE_SERIES(-9223372036854775807,9223372036854775808)ORDER BY 1DESC
SELECT*FROM GENERATE_SERIES(-9223372036854775807,9223372036854775808)ORDER BY 1DESC
SQL Server Performance Office Hours Episode 79 – Dang is it hot again by @erikdarling.com
https://erikdarling.com/sql-server-performance-office-hours-episode-79-dang-is-it-hot-again/?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
https://erikdarling.com/sql-server-performance-office-hours-episode-79-dang-is-it-hot-again/?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
SQL Server Performance Office Hours Episode 79 – Dang is it hot again by @erikdarling.com
SQL Server Performance Office Hours Episode 79 – Dang is it hot again To ask your questions, head over here. Chapters 00:00:00 – Introduction 00:01:28 – TempDb Contention in 2022+ 00:03:57 – Serial Plan on a 32 Core Machine 00:06:04 – Batch Mode Considerations 00:08:45 – Memory Pressure Indicators Full Transcript Erik Darling here with […]
erikdarling.com
September 23, 2026 at 5:30 AM
SQL Server Performance Office Hours Episode 79 – Dang is it hot again by @erikdarling.com
https://erikdarling.com/sql-server-performance-office-hours-episode-79-dang-is-it-hot-again/?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
https://erikdarling.com/sql-server-performance-office-hours-episode-79-dang-is-it-hot-again/?utm_source=bluesky&utm_medium=social&utm_campaign=newsletter
That's because @brento.bsky.social has said that TempDB is the SQL Server equivalent for a public toilet. It's what the model knows.
September 2, 2026 at 9:18 AM
That's because @brento.bsky.social has said that TempDB is the SQL Server equivalent for a public toilet. It's what the model knows.
A bit like tempdb for physical stuff.
September 1, 2026 at 10:52 AM
A bit like tempdb for physical stuff.
Stundenlang Prototypen in der tempdb entworfen (jaja, ich weiß...) und dann startet die IT einfach ohne Vorwarnung meine Maschine neu.
"Kein Bock mehr" reicht als Argument für Feierabend, oder? 🤯
"Kein Bock mehr" reicht als Argument für Feierabend, oder? 🤯
August 31, 2026 at 12:55 PM
Stundenlang Prototypen in der tempdb entworfen (jaja, ich weiß...) und dann startet die IT einfach ohne Vorwarnung meine Maschine neu.
"Kein Bock mehr" reicht als Argument für Feierabend, oder? 🤯
"Kein Bock mehr" reicht als Argument für Feierabend, oder? 🤯
Reading: Temp Table Opinions Roundup www.jefftaylor.io/post/t-sql-t...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
Nine community takes on temp tables in tempdb, summarized: plan boundaries, statistics, scope, and when to reach for one.
www.jefftaylor.io
August 27, 2026 at 8:10 PM
Reading: Temp Table Opinions Roundup www.jefftaylor.io/post/t-sql-t...
August 27, 2026 at 4:01 PM
Temp tables in tempdb: friend or foe? I asked, and nine bloggers answered for T-SQL Tuesday #201.
One of them built a lab. Another swears by CTEs until the exact moment they fall apart. And I took my own dare to see whether I could beat a temp table without one.
One of them built a lab. Another swears by CTEs until the exact moment they fall apart. And I took my own dare to see whether I could beat a temp table without one.
August 27, 2026 at 4:01 PM
Temp tables in tempdb: friend or foe? I asked, and nine bloggers answered for T-SQL Tuesday #201.
One of them built a lab. Another swears by CTEs until the exact moment they fall apart. And I took my own dare to see whether I could beat a temp table without one.
One of them built a lab. Another swears by CTEs until the exact moment they fall apart. And I took my own dare to see whether I could beat a temp table without one.
I'm not going to spoil any of it here. The good stuff (and the numbers) are in the posts.
The round-up, with links to all nine: www.jefftaylor.io/post/t-sql-t...
The original invitation that kicked it off: www.jefftaylor.io/post/t-sql-t...
Which camp are you in?
The round-up, with links to all nine: www.jefftaylor.io/post/t-sql-t...
The original invitation that kicked it off: www.jefftaylor.io/post/t-sql-t...
Which camp are you in?
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
Nine community takes on temp tables in tempdb, summarized: plan boundaries, statistics, scope, and when to reach for one.
www.jefftaylor.io
August 27, 2026 at 4:01 PM
I'm not going to spoil any of it here. The good stuff (and the numbers) are in the posts.
The round-up, with links to all nine: www.jefftaylor.io/post/t-sql-t...
The original invitation that kicked it off: www.jefftaylor.io/post/t-sql-t...
Which camp are you in?
The round-up, with links to all nine: www.jefftaylor.io/post/t-sql-t...
The original invitation that kicked it off: www.jefftaylor.io/post/t-sql-t...
Which camp are you in?
Today's editorial: Never is Not the Policy
Never is Not the Policy
Years ago I worked with a few developers and DBAs that were temp-table happy. As in they defaulted to using temp tables everywhere. This was in SQL Server 6.5, and tempdb was an issue with contention, sizing, and performance. I rewrote so many queries to remove temp tables for our clients that I banned them. I told other developers they could never use temp tables in their SQL code.
voiceofthedba.com
August 19, 2026 at 2:01 PM
Today's editorial: Never is Not the Policy
While TempDB improvements in #SQLServer2025 may not attract the same attention as new AI features, they deliver some of the most impactful operational changes. Find out more: sqlmct.com/tempdb-impro...
TempDB Improvements in SQL Server 2025 Explained
Explore TempDB improvements in SQL Server 2025 to enhance governance, recovery, and monitoring of your database.
sqlmct.com
March 9, 2026 at 11:50 AM
While TempDB improvements in #SQLServer2025 may not attract the same attention as new AI features, they deliver some of the most impactful operational changes. Find out more: sqlmct.com/tempdb-impro...
I don't think tempdb is worth the cost. 🫣
June 18, 2026 at 12:01 AM
I don't think tempdb is worth the cost. 🫣
When you submit a query to SQL Server, it often needs some temporary “scratch” space to store intermediate results and data while processing the query. One key piece of the puzzle is the tempdb system database.
thedbahub.com/understandin...
thedbahub.com/understandin...
April 12, 2024 at 4:03 PM
When you submit a query to SQL Server, it often needs some temporary “scratch” space to store intermediate results and data while processing the query. One key piece of the puzzle is the tempdb system database.
thedbahub.com/understandin...
thedbahub.com/understandin...
This month, I have the honor of hosting T-SQL Tuesday #201, and I picked a topic that comes up on almost every client engagement I do: temp tables in tempdb. Should you use them?
www.jefftaylor.io/post/t-sql-t...
#tsql2sday #SQLServer #tempdb #performancetuning #performance
www.jefftaylor.io/post/t-sql-t...
#tsql2sday #SQLServer #tempdb #performancetuning #performance
August 4, 2026 at 4:02 AM
This month, I have the honor of hosting T-SQL Tuesday #201, and I picked a topic that comes up on almost every client engagement I do: temp tables in tempdb. Should you use them?
www.jefftaylor.io/post/t-sql-t...
#tsql2sday #SQLServer #tempdb #performancetuning #performance
www.jefftaylor.io/post/t-sql-t...
#tsql2sday #SQLServer #tempdb #performancetuning #performance
Ernest Hemmingway once told a sad story in 6 words:
"Managed instance; tempdb contention, unplanned failover"
"Managed instance; tempdb contention, unplanned failover"
What a sad story this is. I feel bad for whoever this was.
The Azure Cloud Chronicles--Azure SQL Managed Instance, Part II
YouTube video by Azure Cloud Chronicles with Microsoft MVPs
youtu.be
August 29, 2025 at 5:36 PM
Ernest Hemmingway once told a sad story in 6 words:
"Managed instance; tempdb contention, unplanned failover"
"Managed instance; tempdb contention, unplanned failover"
All of a sudden, client has crazy PAGELATCH_UP waits. Tempdb is configured correctly, SQL Server version is 2019 CU21.
"Don't restart" I said. They restarted. Problem solved, ready to bite again tomorrow.
"Don't restart" I said. They restarted. Problem solved, ready to bite again tomorrow.
September 27, 2023 at 3:12 PM
All of a sudden, client has crazy PAGELATCH_UP waits. Tempdb is configured correctly, SQL Server version is 2019 CU21.
"Don't restart" I said. They restarted. Problem solved, ready to bite again tomorrow.
"Don't restart" I said. They restarted. Problem solved, ready to bite again tomorrow.
December 3, 2024 at 12:39 AM