Knowing what you want from SQL Server is probably the biggest step toward running it successfully in business applications, according to consultant Koen Verbeeck. It's not just about knowing how SQL ...

Blocking is normal in any lock-based relational database, but persistent or long-running blocking degrades throughput and causes application timeouts. This article describes what blocking is in SQL ...