Forcing Parallelism SQLChallenge (48 minutes)

Can you coerce SQL Server into giving a query a parallel plan, without changing instance wide settings or re-writing the query?
Can you coerce SQL Server into giving a query a parallel plan, without changing instance wide settings or re-writing the query?
Learn why SQL Server's table partitioning feature won't make your queries against disk-based rowstore indexes faster-- and may even make them slower.
Learn to use this Query Store feature to identify and stabilize problem queries.
Sharpen your skills at fighting blocking and index design by defusing this deadlock.
What happens when you use NOLOCK hints in your code, or set your isolation level to READ UNCOMMITTED in SQL Server? Learn the dirty secrets and potential uses of NOLOCK.
Learn the internals of how disk based rowstore indexes work in SQL Server.