SQLServerGeeks Bulletin: July 02, 2020

#1_July_02_2020_Thursday

Hi There,

Here is the all new content-rich SQLServerGeeks Newsletter.

New Blog Posts
• 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.

The Scripts Garage
• 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.
• Index fragmentation is still a matter of concern. Here is a script to find out all the fragmented indexes in a database. Click Here.

Quick SQL Video Tips on Twitter
Faster INSERTs in Tempdb
Query Tuning – Improvising T-SQL Code
Index Tuning – Why is INDEX SEEK not happening?

Latest News from Microsoft SQL Server Team
Expanding SQL Server Big Data Clusters capabilities, now on Red Hat OpenShift
Cumulative Update #5 for SQL Server 2019 RTM
Cumulative Update #13 for SQL Server 2016 SP2

Data Platform Summit (DPS)
• DPS Showcase is up – https://www.DPS10.com
• Data Platform Summit 2020 Teasers have begun. Check this out. (More announcements coming soon)

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

Regards
SQLServerGeeks Team
Follow on Twitter

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

Subscribe to SQLServerGeeks Newsletter | Access Past Newsletters

Data Platform Virtual Summit 2020

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

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Leave a Reply

Your email address will not be published. Required fields are marked *