TechNet Guru Awards - October 2013

I'm a bit behind on posting the TechNet Guru award winners for the past few months, so I'm catching up today.  These awards represent many hours of contribution from each of the contributors, not just the winners, and the community benefits greatly from these articles.  Thanks again to all who participate each month and I look forward to reading future submissions!

Sam Lester (MSFT)


The TechNet Guru Awards celebrate the technical articles on TechNet, contributed from valued wiki authors like YOU!

Each month, the contributions are scored by a panel of judges (5 per category, 2-3 in each are MS experts), and the winners of each category are showered with love and attention from all corners of TechNet.


The October results are in!  With many new SQL Server related TechNet entries, the competition for the October TechNet Guru was very tough!  Here are the final results.  Congratulations to all winners!


Guru Award  Transact-SQL Technical Guru - October 2013  

Gold Award Winner


Naomi N T-SQL Useful Links Samuel Lester: "A treasure trove of amazing resources! I've already found myself referencing your "T-SQL Useful Links" wiki several times and can see this being just as valuable. I know it represents SO many hours of your efforts and it is greatly appreciated!" Jinchun Chen: "Awesome. All-In-One." Richard Mueller: "A great collection of references."

Silver Award Winner


Ronen Ariely Crazy TSQL Queries play time Jinchun Chen: "Really good." Samuel Lester: "As a long time software tester, this article brings me joy! :) Great job breaking the mold and adding content that gives the reader something they likely have never thought about. After reading this, I immediately started thinking of other areas where we could expand this. These are all outstanding learning exercises and would make for great interview questions as you mentioned. I still consider Pinal Dave's SQL Server Interview Q & A as the best around, but I could really see a section added where you tackle problems like these which require deeper knowledge to solve. " Richard Mueller: "An interesting and educational collection of snippets."

Bronze Award Winner


Saeid Hasani All-at-Once Operations in T-SQL Richard Mueller: "Very interesting and informative in an attractive article." Samuel Lester: "Great article! Ask 10 C#/.NET coders this question and see how many get it correct. :) Very strong points in the Silent Death section regarding execution order based on the estimated execution plan. We see this problem trip up many people in the MSDN forum questions and could possibly be a blog/wiki article on its own. "


Guru Award  SQL Server Database Engine Technical Guru - October 2013  

Gold Award Winner


Uwe Ricken Delete huge amount of data from a relation NN: "Very interesting article with great code" Samuel Lester: "Incredible explanation and depth to a question we're seeing more and more often due to data size. Great comparison of different techniques along with why the standard "switch to simple mode" solution won't work in most cases where customers are hitting these bounds." Ed Price: "Amazing formatting and detail!" Jinchun Chen: "Good practice." DRC: "Feedback: • This article is provides a very good information about the topic which is being discussed. • It also provided a sample code which can be tested on SQL instance with sample expected output. • This also talks about other alternate solution and scenarios to which this article is applicable. Suggestions: • Avoid line number in the sample code which needs to be edited in order to execute. • High light the key word which is discussed, also highlight the same in the code sample. Holding an "EXCLUSIVE LOCK (WITH TABLOCK)" on the target table can use all benefits of BULK LOGGED operations. INSERT INTO dbo.bigtable WITH (TABLOCK) (Id, c1, c2, c3) "

Silver Award Winner


Shanky_621 What does 'Log Truncation' counter value signifies in DMV sys.dm_os_performance _counters DRC: "--The article seem to be incomplete --Doesnt include all the points discussed --Don't use the short forms like : BOL MS Perfmon VLF's AFAIT -- Since the code is wrtten with reference to Adventure works database, include the location to download the adventureworks so that the users could download this." NN: "Good article but a bit hard to understand" Samuel Lester: "Great investigative work on this and for digging so deep into it, I learned a lot from your write-up. I emailed a few folks on the Engine team to see if I can find someone who's worked directly on this code. " Ed Price: "I love the "Suggested Reading" section!"