Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: April 2012

Automatic page repair with SQL Server Mirroring

Now and then my colleagues and I find our selves in the middle of a discussion about SQL Server Mirroring versus the more traditional Failover Clustering. Both are features provided by SQL Server for achieving high availability, buth they both have pro’s and con’s that could make a decision hard.… Read more

0 comments, 1,451 reads

Posted in SQL Server Notes from the Field on 24 April 2012

Visualize Wait stats with Microsoft Excel

In our blog post last week: Instance Wide Wait Stats we promised to show You how to visualize the collected wait stats with Microsoft Excel, so this is what this blog post will be about.

The blog post from last week will be the basic setup for this one, so… Read more

0 comments, 583 reads

Posted in SQL Server Notes from the Field on 18 April 2012

Instance Wide Wait Stats

Over the last many weeks we have written quite a few blog post about query debugging, using Extended Events, Blocking sampling and other techniques. Today we are taking a few steps back, and demonstrate how you could start looking at performance problems on a system that you don’t know anything… Read more

1 comments, 1,521 reads

Posted in SQL Server Notes from the Field on 9 April 2012

Nifty queries using a Numbers helper table

(The complete usable code is in the very bottom of this blog post)

Some of you may have seen this “numbers table” technique in use before, but I thought I would share a few simpel examples to those of you that haven’t seen the light yet

Lets start with a… Read more

4 comments, 3,401 reads

Posted in SQL Server Notes from the Field on 4 April 2012