February 2009 - Posts

• Where's that sys.messages management pack?

  I've often been thinking that "somebody" should produce a list and perhaps some ready-made TSQL code of the SQL Server error messages we want to be alerted for. Something like a Management Pack, but not tied to any particular sys mgmt software. Essentially, Read More... Posted Monday, February 23, 2009 9:37 PM by TiborKaraszi | 12 Comments Filed under: Maintenance, Troubleshooting

• Sp_indexinfo updated

  For a long while, I've had a few things I wanted to add for sp_indexinfo (my procedure which returns bunch of information for indexes). Dejan Sarka suggested adding XML indexes as well as making the column list look nicer. I've also had a request to add Read More... Posted Wednesday, February 18, 2009 7:30 PM by TiborKaraszi | 7 Comments Filed under: indexes, Performance