Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt In the lead in to this post, I talked about how the plan cache can be a gold mine of information. There are a number of places that one can … Continue reading Can You Dig It? – Parallelism in the Plan Cache
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt In this new series of posts, I plan to investigate the SQL Server plan cache. We’ll start with a little introduction of the plan cache and move into ways in … Continue reading Can You Dig It? – The Plan Cache
Two things happened to me this morning. First, I woke up and took the written test for the SQL Server Microsoft Certified Master. Second, I failed said exam. While that might be a circumstance for pity, we should all be glad. Where’s the bar? First off, the exam is tough. Anyone that thought that the … Continue reading Cry, Baby, Cry! Failing the MCM Test
One thing that stuck out for me at the PASS Summit was the changes announced for the SQL Server Microsoft Certified Master (MCM) Program. The MCM program is Microsoft’s upper tier database administration certification. It is aimed at providing a validation of skills and knowledge for those with 5 or more years experience with SQL … Continue reading The SQL Server MCM Training Has Changed
Last week, a new white paper was released that discusses supportability roadmaps for ISVs. The white paper is Testing and Developing Supportability Roadmaps for Independent Software Vendor Applications. What a mouthful… aren’t you glad you aren’t working at an ISV? Well, even if you aren’t I’d recommend reading this white paper because it applies to … Continue reading White Paper of Supportability Roadmaps
Alright, up to the last of the changes I’ve made to the index analysis query that I had planned. This makes the fifth post in the series on this query. The previous posts in this complete series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output … Continue reading Return of Index Analysis Part 5
We’ve got through the first three parts of this continued series on the Index Analysis query last week. The previous posts in this complete series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find existing duplicate and overlapping indexes … Continue reading Return of Index Analysis Part 4
Conference Time! The SSWUG Fall 2010 Virtual Conference is starting today. It’ll go on from today through Friday – if might be getting late but you can still attend the conference. It doesn’t matter if you are in the comforts of your living room, office, or couch. You can still sit back where ever you … Continue reading SSWUG Fall 2010 Virtual Conference Starts Today!
Conference Time! The SSWUG Fall 2010 Virtual Conference is coming up this week. On October 20-22, you can attend a conference from the comforts of your living room, office, or couch. And while you are at it you’ll get to sit in on some incredible presentations, interaction with speakers, and chat with other attendees. All … Continue reading SSWUG Fall 2010 Virtual Conference This Week
Missing Numbers Today a developer came up to me and wanted help solving a problem he was running into with a list of numbers. He had a list of 53 numbers in a comma separated list. Unfortunately, the 53 numbers were not all in the table that he was querying. He wanted to know if … Continue reading Finding Missing Values from an Array
Strate SQL 