SQLskills SQL101: Why are Statistics so Important?
In my years working with SQL Server, I’ve found there are a few topics that are often ignored. Ignored because people fear them; they think
Menu
In my years working with SQL Server, I’ve found there are a few topics that are often ignored. Ignored because people fear them; they think
IMPORTANT NOTE: Be sure to read the ENTIRE post as there’s a workaround that QUERYTRACEON is ALLOWED inside of stored procedures… just NOT in an
In Nov 2014, SQLskills made an offer to user group leaders to deliver remote user group sessions in 2015 and we’ve been having great fun delivering
After writing SQLskills procs to analyze data skew and create filtered statistics, I received a couple of emails asking me to further explain the sentence
At PASS Summit 2013 I delivered a presentation titled: Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad (you can watch this session on PASStv
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
I’ve been seeing this over the past few years, imagine this scenario: You have a stored procedure that runs well most of the time but
Time flies when you're having fun, eh? This week Paul and I are in Dublin, Ireland delivering a deep technical "SQL Immersion Event" on Internals,
OK, it seems as though there's A LOT of confusion about what steps are required for proper database maintenance. And, it seems as though some
YES!!! OK, well, I guess I should be more specific because as in most things in SQL Server, the real answer is “it depends”. And
I know that Paul and I recommended that you subscribe to Conor's blog… but have you? He's posted some great details on Partitioning (Part 1
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.