Earlier this month, I presented a session for Pragmatic Works Training on the T's on the selecting the clustered index for a table in a SQL Server database. In the session, titled How Do Non-Clustered Indexes Improve Performance?, in this session I discussed the patterns around non-clustered indexes and why you might choose which patterns for … Continue reading Webcast Follow-Up: How Do Non-Clustered Indexes Improve Performance?
Earlier this month, I presented a session for Pragmatic Works Training on the T's on the selecting the clustered index for a table in a SQL Server database. In the session, titled Choosing Your Clustered Index, in this session I discussed the patterns around choosing clustered indexes and why you might choose one pattern over another. … Continue reading Webcast Follow-Up: Choosing Your Clustered Index
It's not the first Monday of October, instead it's the second Tuesday (oops, had Wednesday in here originally). As we are all busy from time to time, last week's post managed to slip my mind. I was wrapped up with preparing for a birthday and Parallel Data Warehouse training. Many of you, though, are probably … Continue reading October 2013 – Monthly SQL Server Checklist
I'm not old, but I did turn 40 today. If you ask my kids, they are likely to say that I've gotten crabby over the past few years. I haven't shaken my fist at any pesky teenagers, but I've sure complained about thumping cars a time or two. Since a birthday is a time for … Continue reading I’m 40 and I’ve Had Enough
With today's SQL Server instances, there easily be anywhere from a dozen to a hundred databases on a single SQL Server instance. In fact, on my laptop, I currently have almost two dozen databases and these are just from working on projects. Setup a SharePoint server and add a few sites and you'll easily see … Continue reading Can You Dig It? – Find All Plans for a Database
Strate SQL 