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
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
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
IMPORTANT UPDATE: PLEASE REVIEW THIS POST FOR THE UPDATED SCRIPTS: USE THESE: Updates to SQLskills Index Procedures **************************************************** SQL Server has a horrible habit of
I've decided to create a new series of posts – just because you can, doesn't mean you should! These are going to go in a
OK, two in two days? What's wrong with me (is what Paul said) after he said – who are you and where is my wife?
Paul and I chatted with Hilton Giesenow about SQL Server, Sharepoint and Involuntary DBAs. Paul blogged a bit more details about it in the post titled:
I started the series here: https://www.sqlskills.com/blogs/kimberly/post/Spring-cleaning-your-indexes-Part-I.aspx and I want to continue with Part II today by clarifying some great questions/comments that have come up on the
First and foremost, happy spring! I truly hope we’re on the path to summer (although who would know it here – we’re in Florida for
This is a tough topic. It's a big topic and more than any other – I think there are a lot of misunderstandings about what
When you decide to rebuild or reorganzie an index, you have an option to set something called FILLFACTOR. This is probably the MOST IMPORTANT thing
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
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.