Subscribe to this blog
Archives: August 2011
Book Status #1: Indexing for Performance
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… Read more
0 comments, 446 reads
Posted in StrateSQL on 31 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.
Related posts:
Read more0 comments, 124 reads
Posted in StrateSQL on 26 August 2011
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.
Related posts:
Read more0 comments, 155 reads
Posted in StrateSQL on 19 August 2011
PASSMN Presentation – The Creepy DBA
Last night I spoke at the PASSMN August user group meeting. The topic was The Creepy DBA and how you can use the tools within SQL Server to be ”more” creepy.
If you were there and have opinions on the session, please leave a comment below. I’m always looking for… Read more
0 comments, 144 reads
Posted in StrateSQL on 17 August 2011
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… Read more
0 comments, 120 reads
Posted in StrateSQL on 12 August 2011
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…
Related… Read more
0 comments, 121 reads
Posted in StrateSQL on 11 August 2011
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)
2 comments, 136 reads
Posted in StrateSQL on 5 August 2011
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… Read more
0 comments, 166 reads
Posted in StrateSQL on 2 August 2011
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… Read more
0 comments, 237 reads
Posted in StrateSQL on 2 August 2011