Skip to content
SQLInsight

SQLInsight

We Do SQL Right!

  • What’s New
  • Power BI Gallery
  • PowerPoint Downloads
  • About Us
  • Contact Us
  • Home
  • 2012
  • February

Month: February 2012

Determine “Locked Paged” use across your domain…

February 28, 2012 Steve Schneider

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.

SQL 2005, SQL 2008, SQL AdministrationLeave a Comment on Determine “Locked Paged” use across your domain…

Programmatically act on SQL Version

February 28, 2012 Steve Schneider

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…

Read more

SQL 2000, SQL 2005, SQL 2008, SQL AdministrationLeave a Comment on Programmatically act on SQL Version
Copyright SQL Insight 2017 © All rights reserved.
Business Era by mProThemes