Memory-Optimized TempDB Metadata in SQL Server 2019
In this article we look at a new feature in SQL Server 2019 that can help improve TempDB performance.
2019-12-19
tempdb
2019-03-15
801 reads
How to Resize tempdb
When you are setting up a new SQL Server machine you need to determine how big you should make tempdb. To make sure you size tempdb appropriately you should monitor the tempdb space usage. If there are autogrowth events occurring after you have recycled SQL Server than you might want to increase the size of your tempdb data files. If tempdb never uses most of the tempdb space, then you might want to consider decreasing the size of tempdb.
2018-08-21
4,154 reads
Tempdb size resets after a SQL Server service restart
Have you ever checked the size of the SQL Server tempdb after restarting SQL Server to find that it's reset? Simon Liew explains this behaviour.
2017-05-31
3,326 reads
Query details about objects allocated in TEMPDB.
TEMPDB doesn't have to be a black box. Know what objects and processes are causing it to bloat in size.
2017-01-30 (first published: 2016-12-29)
2,242 reads
2016-10-07 (first published: 2016-09-20)
1,562 reads
2016-08-29
1,226 reads
2016-07-28
1,192 reads
2016-07-06
1,308 reads
2016-05-03
1,514 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
KONTAK BCA KCU SIDOARJO Telp:(08218154392)
Alamat Kontak WA CS 08218154392 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo,...
KONTAK BCA KCU RUNGKUT Telp:(08218154392)
Alamat Kontak WA CS 08218154392 Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo,...
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers