Page compression

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  December 19, 2014 at 6:44 am

  #299581

  If i am doing a page compression followed with a shrink database ,does it lock down users to access the data in that database?

  sorry my question is actually for ROW compression not page. Thanks

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  December 19, 2014 at 7:57 am

  #1765713

  it may cause a slow down due to the increased CPU and disk activity

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉