Hi Geeks,

We thank all the attendees who participated in the webcast quiz – 15March 2012 Thurs–Amit Bansal by Amit Bansal. The quiz was hosted here: http://www.sqlservergeeks.com/forums/sqlservergeeks-community/announcements/166/sqlservergeeks-com-bi-weekly-webcast-quiz-thurs-15-mar-index-tuning-by-amit-bansal

The quiz question was:

There is a table TABLE A with 3 columns, col1, col2 & col3. Col1 has a clustered index on it. You create a composite non-clustered index on col2 & 3. The question is: will the non-clustered index automatically include col1?

Option A: Yes

Option B: No

Option C: only if we use INCLUDE clause and include col1

The right answer is Option A:Yes

Many of you have given the right answer; however only 3 lucky winners are selected as the prize recipients. The 3 lucky winners are:

  1.  Illiyaz Syed,
  2. Vishal Gajjar,
  3. Raj Kumar

Congratulations to all the winners!

Winners are requested to send their full address at mamita<at>peoplewareindia<dot>com.

Please note that prizes will be shipped only within India.

We hope our members are enjoying all the community activities that we are conducting. Do continue your participation.





Like us on FaceBook Follow us on Twitter

Join the fastest growing SQL Server group on FaceBook