SQL Server Education (by the geeks, for the geeks)
This blog covers simple yet useful tips and optimization to improve stored procedure performance. 1. Use SET NOCOUNT ON SQL Server returns informational messages when running select or DML operations. In …
Improve stored procedure performance in SQL Server Read MoreHello Geeks and welcome to the Day 35 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful …
sys.dm_exec_procedure_stats – Day 35 – One DMV a Day Read MoreHi Friends, As you already know, the auto update statistics feature of SQL Server relies on number of rows changed or updated to determine if statistics update is needed. The statistics …
SQL Server Trace Flag 2371 to Control Auto update Statistics threshold and behavior in SQL Server Read More