A good cure to a creepy doll is a good old post that is still useful. In this post, I’m going back over some of the posts that came out in this week in previous years. Having looked over these from time to time, I’m always surprised to find old posts that cover current topics that I had planned to write. If they’re still useful to me, maybe they’ll be useful to you as well. The posts for this past week in previous years are:
- XQuery for the Non-Expert – @Variable Use (17 Jan, 2011)
- 31 Days of SSIS – Environmental Variable(17/31) (17 Jan, 2011)
- STATS_DATE() Doesn’t Indicate The Validity of Statistics (17 Jan, 2013)
- 31 Days of SSIS – SQL Server Configuration (18/31) (18 Jan, 2011)
- 31 Days of SSIS – DTSConfig Configuration (19/31) (19 Jan, 2011)
- 31 Days of SSIS – No More Procedures (20/31) (20 Jan, 2011)
- 31 Days of SSIS – Controlling Your Flow In The Control Flow (21/31) (21 Jan, 2011)
- 31 Days of SSIS – Data Flow Expressions (22/31) (22 Jan, 2011)
- 31 Days of SSIS – Generating Row Numbers (23/31) (23 Jan, 2011)
- 5 MCM Readiness Indexing Videos You Should Watch (23 Jan, 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.