(Pinal Dave) Today, I have a very interesting scenario while I was working with my client on the Comprehensive Database Performance Health Check. Let us today talk about SSMS Query Execution configuration for SQL Server where SET ROWCOUNT settings gave us an interesting challenge with query tuning.