Browse by Tags

• SQL Server 2008

• Make sure you play with data collector on a virtual machine

  I'm in a situation where I have configured the new data collector functionality for three instances. And there's no way to undo the config performed by the wizard! It cannot be undone by the wizard, and BOL doesn't have information on how to do this. Read More... Posted Monday, August 25, 2008 7:42 PM by TiborKaraszi | 1 Comments Filed under: Tools, Performance, SQL Server 2008

• Non-trusted constraints and performance

  (See my part 1 article about non-trusted constraints in general: http://sqlblog.com/blogs/tibor_karaszi/archive/2008/01/12/non-trusted-constraints.aspx ) The optimizer is a pretty smart little animal. It can even use constraints to eliminate some data Read More... Posted Saturday, January 12, 2008 6:09 PM by TiborKaraszi | 2 Comments Filed under: Tools, Performance