Karol Papaj

SQL Server, coffee & rock'n'roll

Former SQL Server MVP (2008-2011), coffee lover & hardrocker.
Amateur football player and aquarist, if time permits.

Small, but useful SSMS tip

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