Blogs

/Blogs

LIVE Troubleshooting on Production Server – Plan Cache Bloating

Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive newsletter ConnectWithAB.

By |March 4th, 2021|Categories: SQL Server|Comments Off on LIVE Troubleshooting on Production Server – Plan Cache Bloating

LIVE Troubleshooting on Production Server – Physical vs Logical IO

Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive newsletter ConnectWithAB.

By |March 1st, 2021|Categories: SQL Server|Comments Off on LIVE Troubleshooting on Production Server – Physical vs Logical IO

SARGability and Selectivity in SQL Server

Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive newsletter ConnectWithAB.

By |February 25th, 2021|Categories: SQL Server|Comments Off on SARGability and Selectivity in SQL Server

Finding Expensive Lookups in SQL Server

Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive newsletter ConnectWithAB.

By |February 24th, 2021|Categories: SQL Server|Comments Off on Finding Expensive Lookups in SQL Server

Why are Missing Index Hints Missing

This blog post first appeared on SQLMaestros. Let’s understand a few reasons why SQL Server (sometimes) does not show missing index hints. We are using AdventureWorks2016 database for the demo. Let’s make a copy of [...]

By |February 22nd, 2021|Categories: SQL Server|Comments Off on Why are Missing Index Hints Missing

Keynote Speaker – Rohan Kumar (CVP, Azure Data, Microsoft)

The full virtual tour of DPS 2020 has been released. Watch now. Hi There, We are thrilled to announce Rohan Kumar (Corporate Vice President, Azure Data, Microsoft Corporation) as the keynote speaker for Data Platform [...]

By |November 12th, 2020|Categories: DPG Bulletin|Comments Off on Keynote Speaker – Rohan Kumar (CVP, Azure Data, Microsoft)