As some of you may know, I am writing a book on indexing. So far I’ve written and submitted four of the chapters to the publisher. If anyone ever says, “Writing a book is easy” – kick them. When they tell you – “it’s really hard” you might want to have them kick you. Writing … Continue reading Book Status #1: Indexing for Performance
Month: August 2011
Re-blog – August 19-August 25
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts of interest that you may want to check out are: Reporting Services Resources (8/22/2007) Find Tables and Columns by Data Type (8/24/2010) Enjoy.
Re-blog – August 12-August 18
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts of interest that you may want to check out are: Find The Heap Indexes (8/13/2008) Enjoy.
Can You Dig It? – Researching Index Scans
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. It’s been a while since the last plan cache series post. In the last few posts, I was focusing on specific attributes. Instead of continuing on that vein, I want to cover a use case that fit … Continue reading Can You Dig It? – Researching Index Scans
Re-blog – August 5-August 11
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Oddly enough, in four years of blogging I’ve not blogged in this week before – guess I’ll need to do something about that. Maybe they’ll be better luck next week…
Re-blog – July 29-August 4
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts of interest that you may want to check out are: Gotta Stop Violating Foreign Keys (7/29/2009) Finding Number of Reports Executed By Folder (7/30/2009) Analyzing Report Execution Time (7/31/2009) Enjoy.
Minnesota SQL Server Study Group (August)
Last month, I started using Meetup to schedule SQL Server Study Group events. The idea is to meet twice a month with people that want to just talk about SQL Server and help fill in the holes in their knowledge. Unfortunately, due to a recent move and a personal development retreat coming up, I will … Continue reading Minnesota SQL Server Study Group (August)
August Monthly SQL Server Checklist
First day of the month and first Monday of the month. The list is coming out a bit late due to these, hopefully you were more on top of this that I was. As I mentioned back in June, the premise of this post is help DBAs maintain their environments by getting together a monthly … Continue reading August Monthly SQL Server Checklist
Strate SQL 