SQL Server / Query Optimization / Memory Grant Warning / Excessive Grant

Posted by in SQL Server on Apr 21st, 2018 | 0 comments
SQL Server / Query Optimization / Memory Grant Warning / Excessive Grant
Recently we had really nice meetup gathering here in Auckland. Was a beautiful evening, there were 20 people talking about SQL server, was perfect. One of the topics was “Bad estimates and Memory Grant Warning” For this demo I used SQL Server 2014 Developer Edition. As a database I used StackOverflow, you can download this DB from Brent Ozar web page, just follow the instructions How to Download the Stack Overflow Database via BitTorrent   In the previous post we talked about using string function in the WHERE clause and bad estimates...
read more

SQL Server / Query Optimization / String functions in the WHERE clause and bad estimates

Posted by in SQL Server on Apr 19th, 2018 | 2 comments
SQL Server / Query Optimization / String functions in the WHERE clause and bad estimates
Recently we had really nice meetup gathering here in Auckland NZ. Was a beautiful evening, there were 20 people talking about SQL server, was perfect. One of the topics was “String functions in the where clause and bad estimates” For this demo I used SQL Server 2014 Developer Edition. As a database I used StackOverflow, you can download this DB from Brent Ozar web page, just follow the instructions How to Download the Stack Overflow Database via BitTorrent   Using string function in the WHERE clause can cause bad estimates. I...
read more