SQL Server Index Internals and Tuning Column Sort Order (by Amit Bansal)
Learn about the largest online learning event on Azure Data, Analytics & AI covering 30+ technologies including SQL Server, Power BI, MS AI stack, Azure Data stack & Advanced Analytics stack: https://www.DataPlatformVirtualSummit...
Follow us on Twitter
/ thedatageeks
/ sqlservergeeks
/ dataaisummit
/ sqlmaestros
/ a_bansal
.
.
Not sure whether to call this Query Tuning or Index Tuning, anyway, all that matters is we get improved performance. In this video you will see how that importance of column order in an index, especially the SORT mechanism.
Important Links:
DataPlatformGeeks: https://www.dataplatformgeeks.com/
SQLServerGeeks: https://www.SQLServerGeeks.com
Browse free learning material from our knowledge partner: https://www.SQLMaestros.com