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
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 morning, as I was prepping for my PASS Data Architecture Virtual Chapter presentation on “Why Physical Database Design Matters,” I went to tweet that
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
[NOTE: Update 12 Nov 2014. The most recent bug (KB article KB2965069) is THANKFULLY very unlikely for most environments (mentioned below). As a result, I’m glad
There’s a lot of confusion around duplicate indexes and I think a lot of it has to do with how sp_helpindex (or even SSMS) display
Data Dude (Visual Studio "DBPro") has generally been an expensive tool – only in the "Team Systems" Edition of Visual Studio. But, that's all going
A couple of weeks ago I wrote a blog post titled Whose job is it anyway? It's an interesting debate and something I've been hearing more
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
OK, I was tagged by Ward Pond here. Ward was tagged by Jimmy May here. Jimmy was tagged by Kevin Kline here. Kevin was tagged
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
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
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.