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 ...

Testing and tuning SQL is an often-overlooked aspect of incorporating the database into your DevOps pipeline. It is important to be able to analyze and optimize SQL performance within your application ...

Database applications have vastly improved in recent years, but despite our best efforts, they can still feel frustratingly slow. A report that is supposed to take minutes might instead (for unknown ...

I have a cloud hosted (Rackspace) Windows server running SQL 2008 R2 Express, which is supposedly limited to using 1 GB of RAM. Performance has not been what we wanted, so we had Rackspace deploy for ...

As a consultant whose job description includes putting out performance fires, I get to see a lot of problematic queries that can dramatically harm overall server performance and throughput. Wondering ...