-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: January 2015

Trapping Online Index Operations

Recently I wrote an article about Capturing Online Index Operations.  In that article, I discussed a problem that I had encountered.  Well, there were multiple problems.  One was an issue with a vendor app that had some hidden module that was performing online index defrags that was causing corruption… Read more

4 comments, 990 reads

Posted in SQL RNNR on 29 January 2015

Minor ailments and Healthy SQL

One of the things that DBAs love to do is keep their servers running and healthy.  A healthy server, after all, is your ticket to a stress free day and a full night’s sleep.  Granted this not a guarantee but it sure helps make life easier.

We are always looking… Read more

1 comments, 711 reads

Posted in SQL RNNR on 13 January 2015

Las Vegas UG This week

What a fun week we have tuned up for the folks in Las Vegas.  It is the first full week of January and there is this huge convention going on near the strip.  And as timing would have it, this week is also the perfect time to have our User… Read more

0 comments, 446 reads

Posted in SQL RNNR on 5 January 2015

Effects of Max Mem on Plan Cache

Reading a Microsoft Article (which can be found here) while making sure I understood what can cause a query plan to be recompiled or removed from the plan cache, I got to thinking a bit.

In the article, it lists the following as things that can cause a… Read more

10 comments, 6,763 reads

Posted in SQL RNNR on 5 January 2015