April 2010 - Posts

• Mirroring: what happens if principal loses contact with both mirror and wittness?

  Imagine a database mirroring setup where you have two LANs with a WAN link in between. Let's call them site A and site B. Say that principal is currently in site A, and both mirror and witness are in site B. I.e., we are running database mirroring with Read More... Posted Friday, April 16, 2010 8:46 AM by TiborKaraszi | 6 Comments Filed under: Availability

• Updated article "Agent Alerts Management Pack"

  I've just updated the "Agent Alerts Management Pack" found here . I realize that some don't feel confident in reading and executing T-SQL code and they instead prefer to point & click in SSMS instead. So I added two tables with my suggestion on the Read More... Posted Sunday, April 11, 2010 6:07 PM by TiborKaraszi | 0 Comments Filed under: Maintenance, SQL Server Agent

• How selective do we need to be for an index to be used?

  You know the answer already: It depends. But I often see some percentage value quoted and the point of this post is to show that there is no such percentage value. To get the most out of this blog post, you should understand the basic structure for an Read More... Posted Thursday, April 01, 2010 10:39 AM by TiborKaraszi | 15 Comments Filed under: Performance, indexes