Explicitly naming CL key columns in NC indexes – when and why
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
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
Something that always amazes me is that people think SQL Server is easy. And, I’d like to (at least partially) blame Microsoft marketing for that.
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,
OK, for years I've been saying that SQL Server doesn't care about the order in which you define the columns of your table because internally
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
(Be sure to join our community to get our monthly newsletter with exclusive content, advance notice of classes with discount codes, and other SQL Server
OK, so, I don't blog very often. I don't know what it is… I think it's that I feel like I always need to blog
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
Been thinking a lot about something that was mentioned in a few of my most recent posts… Especially when I get comments like “that’s another item
Hey there everyone! I know I still owe you a few Q&A entries (for sessions 7, 8 and 9) but I wanted to get this
This is a much needed and much overdue blog entry… In 8 Steps to Better Transaction Log throughput, I mentioned a customer that was helped
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.