Brent Ozar published a new blog post today, Brent Ozar published a new blog post today called SQL Server TV Shows, and I just HAD to come up with something good. So let’s see, TV shows that haven’t already been taken…so you think you can dance, nah. House, MD…nah. American Idol, Dexter, iCarly, Yo Gabba […]
Category: Uncategorized
Spotlight: Wendy Pastrick
I’m reasonably certain that I have a venn diagram of people who follow me on Twitter and people who read my blog: some do one or the other, some do both. So it behooves me from time to time to show Twitter to blog readers, and vice versa. It helps you too, to meet some […]
Get Index Included Column Info
Content rating: Beginner, tip One of my pet peeves with SQL is that there isn’t a quick and easy way to get all the information about indexes. Sure, you have sp_help tablename or sp_helpindex tablename to get the index name and keys for a table, but that’s not even half the story. I use a lot […]