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

Archives: February 2011

Memory Consumed By SQLServer

Have you wondered how much memory was being consumed by SQL Server?  Have you wondered if there was a way to find out that information from a tSQL command?

On occasion it would be nice to be able to find this information.  A command was provided for this very purpose.… Read more

6 comments, 3,489 reads

Posted in SQL RNNR on 28 February 2011

Finding Compressed Tables

Have you been working with compression?  Have you inherited a database that may or may not have some tables compressed?  On occasion you may want to know what the compression type being used on a table is.  There is a really easy way to figure that out.

This is also… Read more

0 comments, 1,951 reads

Posted in SQL RNNR on 25 February 2011

February 2010 S3OLV Recap

For the month of February, I conducted the S3OLV meeting virtually from the confines of home in Utah.  As you may know, I have moved from Vegas back to Utah.  Despite having moved away from Vegas, I am still helping with the User Group in any way that I can.… Read more

0 comments, 435 reads

Posted in SQL RNNR on 22 February 2011

SQLServerPedia Blogger Awards

Several moons ago I learned that I had won one of the categories for the 2010 SQLServerpedia Blogger Awards.  You can read about that here.  Of all of the promises made in that post, I have yet to fulfill two of them (one is being fulfilled now).  I can’t… Read more

3 comments, 467 reads

Posted in SQL RNNR on 17 February 2011

PASS Summit Volunteers Needed

Well, we are coming around into a new year.  With this new year there is once again PASS Summit preparations that are well under way.  Time has come again for people to volunteer to help with PASS Summit.  The call has gone out!!  Allen Kinsel has blogged about it here Read more

4 comments, 611 reads

Posted in SQL RNNR on 16 February 2011

Feb 2011 S3OLV Meeting

I am getting this out extremely late.  I seriously have good excuses for that.  Due to my location and Charley feeling ill, we will be doing the S3OLV UG meeting entirely virtual this month.

Here is the note on the invite:

Please join us this month for a Virtual UG… Read more

0 comments, 330 reads

Posted in SQL RNNR on 9 February 2011

T-SQL Tuesday #15 DBA Automaton

I have been incognito for the last couple of weeks and nearly missed TSQL Tuesday this month.  If it weren’t for somebody pinging me requesting the link to the list of upcoming hosts, I would have missed it entirely.  The topic merges well with the work I have been doing… Read more

0 comments, 804 reads

Posted in SQL RNNR on 9 February 2011

Immersions Training

The last week of January 2011, I wrote a blog post entering a contest for free training at the hands of SQLSkills.  Later that week an announcement was made as to the winner(s) of that contest.  Lo and behold I found out that I was one of the winners.  Totally… Read more

0 comments, 522 reads

Posted in SQL RNNR on 8 February 2011