Dec 23 2011
On the Tenth day of Christmas I Give a Gift to Thee…Ten Quick Hit Thumbscripts A Nine Hour Work Day I FORGOT WHAT EIGHT WAS FOR… Seven Reports to Start My Day Six Gb of RAM Five Volumes Minimum… Four Words to Live By… Three Training Events… Two Twitter Handles… and Mirrored Disks with Parity [...]
Dec 21 2010
In my preparations for all my presentations for 2011 regarding Dynamic Management Views and Functions as well as my consolidation efforts of instances at work, I found myself mulling over the easiest way to capture some of the metrics I would be using for determining current load on my SQL Server instances and capacity planning [...]
Apr 21 2010
First of all I can’t take credit for this. The credit for what I’m about to show you comes courtesy of Steve Jones and the crew of 1,000s over at SQLServerCentral. When I stumbled across this today I felt like Charlie Sheen on a bender in Amsterdam. What am I talking about? Well, it’s about turning SQL Server Management Studio [...]
Sep 11 2009
You would expect that a unique combination of database_id, object_id, index_id, and partition_number would be returned when calling sys.dm_db_index_operational_stats. Sometimes it does and sometimes it does not. SQL Server should not be a “sometimes” environment.
Dec 22 2008
It’s getting harder to remember when there was such a thing as downtime. We used to end our work days and go home to relax. Now we fire up our Professional Persona for the SQLverse and dig in after hours.
Dec 5 2008
I’ve just finished an article outlining high points from the PASS 2008 Community Summit. The article is available at MSSQLTips.com.
