SQLskills SQL101: Indexing Basics
SQLskills introduced our new SQL101 recently and well… indexing is something that everyone needs to get right. But, it’s not a simple task. And, as I start
Menu
SQLskills introduced our new SQL101 recently and well… indexing is something that everyone needs to get right. But, it’s not a simple task. And, as I start
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
Since I’ve rewritten sp_helpindex a few times, I have a few blogs posts in this category. Each time I do an update I’ll make the
I know it’s been a while since I last blogged here on SQLskills. It’s been a busy few months with Immersion Events, conferences and even
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
Well, it's been a crazy few weeks! Paul and I have been booked solid with client engagements, Immersion Events, conferences and other things (like chapter
I realize that I’ve created quite a few posts (and rewrites) around sp_helpindex and recently I’ve been recommending that most folks use my latest version
OK, I've talked about the clustering key many times. Here, I thought I'd bring together one final series of details (and links) to help you
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?
. THAT'S NOT THE POINT!!! . The simple point is that bad (or sloppy/lazy) design cannot be tuned. If you think that data type choice,
NOTE: I’ve released other versions of sp_helpindex since this post. Check out the category: sp_helpindex rewrites for all of the options! OK, I first blogged about
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.