As you may have read by now, I am leaving my current position and joining SQLskills. I am thrilled to be joining the team and look forward to working with Paul, Kimberly, Jonathan, Joe and Glenn. I expect to end every day utterly exhausted because of all the new things I’ve seen and learned. I…
Presenting for the PASS DBA Virtual Chapter this week
SQLRally kicks off this week in Dallas, Texas and to all those presenting and attending, I hope you have a great time! May is always an extremely busy month for me so I will not be attending SQLRally, but I will be presenting this week via the PASS DBA Virtual Chapter. If you want to…
varchar(max) in an Index
There is one more attendee question from SQLSaturday #118 that I want to follow up on, and it is this: “Is there any way to create an index with a varchar(max) column as the leading column?” This question came up during my Statistics presentation, and was at the end as we were winding down. My…
sysrscols and Disabling Auto Update Statistics
As I mentioned in my last post, one of the sessions I presented last weekend at SQLSaturday #118 was on statistics, and an interesting topic that came up toward the end of the session was the Auto Update Statistics option. I’ve blogged about this option before, and whether or not you leave it enabled for…
