Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time to dig out some old posts and find out if there are any undiscovered finds there. In this post, I’m bringing up some of my old posts to give them a chance for re-discovery. Maybe there’s one or two that will help you solve a problem that you are currently facing.
The posts for this past week in previous years are:
- Troubleshooting Performance Problems in SQL Server 2005 (11 Apr, 2007)
- Populating Birthday From Contacts (11 Apr, 2009)
- Discover SQL Server 2008 R2 (11 Apr, 2010)
- Entertainment for the Traveling Consultant (UltraViolet Review) (11 Apr, 2013)
- I See BI People (11 Apr, 2013)
- TSQL Tuesday #005 – Wait Stat Report – #TSQL2sDay (13 Apr, 2010)
- FileSystemHelper SQL Server CLR – Codeplex (14 Apr, 2010)
- Free eBook – Introducing SQL Server 2008 R2 (15 Apr, 2010)
- Blogging Again… (17 Apr, 2009)
- A Replacement for DBCC IND in SQL Server 2012 (17 Apr, 2013)
Do you have something from years gone by that was posted during this week? If so, leave a comment below and we’ll give some new life to good knowledge.
Find all you need to know about indexes in one book. Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. All of this will help you progress towards properly achieving your database performance goals.