Category Archives: SQLSaturday

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…

A Consideration When Rebuilding a Corrupt NonClustered Index

This past weekend I was in Madison, WI for SQLSaturday #118 and it was a fantastic event.  Jes Borland ( b | t ) and her team did a great job of hosting their first SQLSaturday and I was honored to present twice.  I presented a new session, DBCC Commands: The Quick and the Dangerous,…

Statistics at SQLSaturday #85

This week I’m on vacation with my family in sunny Orlando.  As luck would have it, the SQLSaturday powers-that-be scheduled SQLSaturday #85 here in Orlando this weekend.  I submitted a few sessions and had one selected!  If you want to learn about statistics, I would love to see you at my session, “You’re My Density:…

Session News

It’s after 11 PM, I’m sitting in my hotel room, and this is pretty much the expression I’ve had all afternoon: See, emails about PASS Summit sessions went out this afternoon and I was thrilled to learn that two sessions I submitted have been accepted. Woohoo!! I am very honored and want to thank the…