Hi There,

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. Also a two-minute video on Twitter. See here.

S-arg-ability is a much spoken term in SQL Server world. We took a fresh approach to this topic and penned down quite a few things including SCAN, SEEK, CAST, CONVERT, etc, kind of Sargability ramblings. Read the full blog post. Hope you find it interesting.

Clustered Index is good. In most cases. You might have tables in your environment that do not have a clustered index. Find them quickly with this script. Click Here.

That’s it for today. Feel free to forward this to your friends & colleagues. Bringing you more learning content on weekly basis.

SQLMaestros Team
Follow on Twitter

SQL Server Performance Tuning, Querying & Programming Video Courses are now LIVE. Corporate subscriptions have begun. Learn More.

Subscribe to SQLMaestros Newsletter | Access Past Newsletters

— End of Bulletin —

Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter