Monthly Archives: February 2012

Determine “Locked Paged” use across your domain…

So, building on my previous blog entry, now, let’s open a multi-server query and run this script that follows.  It will tell you for each server it’s version and how much memory is in locked pages.

Posted in SQL 2005, SQL 2008, SQL Administration | Leave a comment

Programmatically act on SQL Version

I often have scripts that run across multiple versions of SQL … more and more 2008’s and less and less 2000’s.  In doing so, i need to take different actions based on that version.  Here’s the simple technique that i … Continue reading

Posted in SQL 2000, SQL 2005, SQL 2008, SQL Administration | Leave a comment