Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...

Need more info why it's running like a dog; do you notice when you run a query that it takes a while to get results back? What are you exactly doing with the database?

New AI capabilities help DBAs move from performance visibility to performance resolution—turning slow queries into actionable index recommendations in minutes HOUSTON, March 19, 2026 /PRNewswire/ -- ...

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...