SQL Server Tempdb Improvements from 2014 to 2022 with demos

[@ssk3532]

Thanks for sharing

[@vamsychiranjeevi9619]

Thanks for watching!

[@Rajani1200]

Thank you 🙏

[@shoaibsalmani1187]

As always wonderfully explained

[@vamsychiranjeevi9619]

Glad you liked it

[@brijeshbind4832]

nicely explained..

[@vamsychiranjeevi9619]

Thanks for liking

[@babban2020]

Hello Brother, you had mentioned at the of the vid on how to fund out tempdb..contentions...could you please make a vid or tell the queries you said are available on the net??

[@ravi204834]

1117 &1118 is not applicable for only tempdb . It is applicable for user databases as well

[@vamsychiranjeevi9619]

Yes it is applicable but in a slightly different manner though. By default Mixed Extent allocation is OFF. you can turn it on using ALTER DATABASE DBname SET MIXED_PAGE_ALLOCATION ON;

[@rahulmistry3777]

Hi do you take online class ??SQL DBA and Performance tuning

[@vamsychiranjeevi9619]

yes I do you can reach me on my WhatsApp [phone]

[@Greatest.Everrr]

How about pre-size tempdb files and do not let any user run inefficient queries period.

[@vamsychiranjeevi9619]

Well....the query will fail due to 1105 error as it will reach its max size

[@Greatest.Everrr]

houston v have a problem 😁

[@miguelsanchez10]

I think you’re wrong with some concepts dude

[@vamsychiranjeevi9619]

Kindly correct me where I went wrong. I am happy to correct myself.