SQL Server optimizes Tempdb so that your CRUD operations go faster. There are many ways how this is done. One of them is optimized logging or minimal logging. Read the full blog post. I also posted a quick two-minute video on Twitter. See here.
Hope you read through the loooong post about Sargability.
Next, I am working on the concept of Eager Writes. Hopefully in next ConnectWithAB you will see a blog post and a video.
That’s it for today. Feel free to forward this to your friends. Hope to stay connected with you.
Follow me on Twitter
SQL Server Performance Tuning, Querying & Programming Video Courses are now LIVE. Corporate subscriptions have begun. Learn More.