I am moving the TSQL challenges to a new ‘exclusive’ blog that is dedicated only for TSQL challenges. The new site will function in a little more organized and structured manner. We will come up with a new challenge every week(friday) and make sure that the we will announce the winners on the monday after the closing date of the challenge.
I would like to invite everyone to the April Meeting of Ahmedabad SQL Server UG. We will meet tomorrow (Saturday, 18 April 2009) at our new office, 302 OLIVE ARCADE, OPP Samudra Anexe, OFF CG Road, Ahmedabad at 6 PM.
This month, we will discuss the XML features of SQL Server 2008 and as usual will have a QA session to discuss general SQL Server Topics. We will also discuss the community plans for the upcoming Tech-ED India 2009 and the discount options for the UG members. There will be some give-away items in addition to the usual ice-cream and snacks :-)
There are a couple of new SQL Server 2008 white papers published this week. The first one is on “Service Broker Performance Scalability Techniques” and the second is on “Partitioned Tables and Index Strategies”
I am a little late to post details of the UG meeting held on 21st February 2009, and I feel bad for keeping you waiting for so long. I was busy finishing some assignments at work. I am flying to Seattle tomorrow to attend the MVP Global Summit. I hope I will have a great time meeting other SQL Server MVPs and many of the SQL Server Team members.
Coming back to the UG meeting, we really had a wonderful time discussing many of the basic SQL Server questions. Pinal Dave has already posted a very detailed blog post covering the activities. He did a wonderful session where he presented some very interesting points related to the way SQL Server Query Optimizer uses indexes.
My session was more of an interactive discussion. While writing my series of posts on SQL Server IDENTITY columns, I came across several interesting questions and I then compiled a long list of 65 questions. We discussed those 65 questions and their answers and the 'why-how' part of each of them. I will create a PDF document with those questions and will make them available for download.