MSSQL

What’s Worse Than a NULL? An Incorrect NULL

What’s Worse Than a NULL? An Incorrect NULL

Recently it was brought to my attention that the query_hash and query_plan_hash columns inside of sys.dm_exec_requests were returning NULL values. I think everyone knows how I feel about NULLs already, but this was slightly more concerning. See, I work for a company that makes this wonderful tool called Database Performance Analyzer (DPA), and we rely(…)

You Need Three Heads To Read This Post Properly

You Need Three Heads To Read This Post Properly

I have a handful of things to share today. As a DBA it is my nature to be both driven and lazy so instead of three posts I am just going to combine them into one. You’re welcome. Here’s the first item for you: Recently Grant Fritchey (blog | @gfritchey) wrote an article titled “Be Cautious Offering Guidance”. The point(…)

Administering SQL Server 2012 Running On Windows Server Core

Administering SQL Server 2012 Running On Windows Server Core

Are you afraid of deploying (or supporting) an instance of Windows Server Core? Are you telling others to “stay away” because of your own fears of doing something new? Then I am here to tell you that you’re doing it wrong. Last month I decided that it was time to get down and dirty with(…)

Rebuilding Indexes Will Reset Index Usage Statistics in SQL Server 2012

Rebuilding Indexes Will Reset Index Usage Statistics in SQL Server 2012

We all know that statistics get updated when you rebuild your indexes, right? OK, for those of you that are not aware of such things here is a blog post from Benjamin Nevarez (blog | @BenjaminNevarez) on the topic. He does a great job of explaining the subtle differences involved with various index and statistics(…)

Predictive Analysis: I Bet You Didn’t Know I Would Blog This Today

Predictive Analysis: I Bet You Didn’t Know I Would Blog This Today

Quick question: Where would you go to find some basil in your local grocery store? Did you say “by the other herbs?” Or did you say “by the tomatoes?” If you are like me, then you would go looking for basil by the other herbs because, well, that is a natural, logical grouping of products.(…)

Load More