Even with the fastest of CPUs and Storage, Page Splits are still very bad. Also leads to fragmentation. Here is a quick video that shows how you can capture page splits using extended events.
Age old topic but still very important even in the age of SSDs. Watch the demo.
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.
This is a follow up video to part 1. In this quick video you will see that SQL Server is better off with explicit conversion at it likes it.
In this quick video you will understand the concept of implicit conversions and why are they bad for your query performance. This is Part 1.
In this quick video you will understand how to enable global trace flags.
In this video you will understand how to find out the memory consumption by buffer pool and break it up further by databases and objects.