How I Cut SQL Query Time from 45 Seconds to 8 Seconds on 2.3 Million Rows

← 피드로

I inherited a SQL Server database with 2.3 million rows. Queries took 45 seconds. Users were frustrated. Dashboards timed out. Here is exactly what I did. Step 1: Find the slowest queries I used SQL Server's query store to identify the top 10 worst performing…

원문 보기 ↗