Karol PapajSQL Server, coffee & rock'n'roll
Former SQL Server MVP (2008-2011), coffee lover & hardrocker.
Amateur football player and aquarist, if time permits.
In my recent project I ran into situation, where I had to turn off page compression on some of the indexes. Unfortunately, indexes were dropped and re-created in stored procedures, so I had to identify those procedures and change the data_compression setting from PAGE...read more
One of the techniques for query performance troubleshooting is to compare Actual and Estimated Execution Plans. In the most cases, both plan shapes are identical and the only difference is in the runtime statistics (ActualNumberOfRows, ActualExecution, MemoryGrant,...read more