Categories

19 pages

Performance & Tuning

Indexed View can’t create online in the beginning.

Update statistics blocking issue(Part 1)

Delayed Durability

parameter sniffing recompile options

SQL Server Column store row group investigation

Memory troubleshooting

SQL server 2016 -T1117 and -T1118

SOS_SCHEDULER_YIELD due to SpinLock issue.

Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 with high-performance workloads

Parallelism

Drop certain query plan

TempDB Misconceptions around TF 1118