Inside Tempdb - Bob Ward

Perhaps one of the most frustrating, least understood, and contentious areas (no pun intended) of the SQL Server Engine is tempdb. In this half-day session, we will drive into the internals of the tempdb database. I will warn you up front. This is a 500 level session and will be a very deep internal discussion. It will be very fast-paced with much information to consume. As with past presentations I've done I will be using tools like the Windows Debugger, DMVs, DBCC commands, and possibly even hex editors. I will use as aid in presentation details of memory structures, classes, and bitmaps, Even with the depth of this presentation, I believe anyone will walk away with many practical pieces of knowledge and advice that can help you avoid problems and maximize your usage of tempdb.

Видео Inside Tempdb - Bob Ward канала PASStv