New Blog Posts
• Double Read – Reading The Same Record Twice. Watch a two-minute video on Twitter. Also read the full blog post. Click Here.
• Deadlock Due To Bookmark Lookups – Read the full blog post.
The Scripts Garage
• How to Defragment All The Indexes In a Database. Click Here.
• Find FillFactor of All Indexes in a Database. Click Here.
• How to Identify Whether Optimizer is Reusing the Plans or Not. Click Here.
• Find Top 10 CPU Intensive Queries. Click Here.
Quick SQL Video Tips on Twitter
• Double Read – Reading The Same Record Twice
• Deadlock Within a Single Table (Due to Bookmark Lookup)
• SQL Server 2019 – Memory Grant Feedback
Latest News from Microsoft SQL Server Team
Cumulative Update #21 for SQL Server 2017 RTM
Data Platform Summit 2020 – The Big News is Coming!
That’s it for today. Feel free to forward this to your friends & colleagues. Bringing you more learning content on weekly basis.
Follow on Twitter
KP Notification: SQL Server Performance Tuning, Querying & Programming Video Courses are now LIVE. Corporate subscriptions have begun. Learn More.