Memory grants, now here's a fun thing that can pretty much take your SQL Server to its knees. The Symptoms The first thing that you're going to notice is that your SQL Server is going to be running slowly and I mean, slooooooow! When I've got a server on a serious go slow, the first... Continue Reading →