SQL SERVER – Clustered Index and Primary Key – Contest Win Joes 2 Pros Combo (USD 198) – Day 3 of 5

SQL SERVER - Clustered Index and Primary Key - Contest Win Joes 2 Pros Combo (USD 198) - Day 3 of 5 combos

August 2011 we ran a contest where every day we give away one book for an entire month. The contest had extreme success. Lots of people participated and lots of give away. I have received lots of questions if we are doing something similar this month. Absolutely, instead of running a contest a month long we are doing something more interesting. We are giving away USD 198 worth gift every day for this week. We are giving away Joes 2 Pros 5 Volumes (BOOK) SQL 2008 Development Certification Training Kit every day. One copy in India and One in USA. Total 2 of the giveaway (worth USD 198). All the gifts are sponsored from the Joes 2 Pros.

The books are available here Amazon | Flipkart 

How to Win:

  • Read the Question
  • Read the Hints
  • Answer the Quiz in Contact Form in following format
    • Question
    • Answer
    • Name of the country (The contest is open for USA and India residents only)
  • 2 Winners will be randomly selected announced on August 20th.

Question of the Day:

Which of the following datatype is usually NOT the best choice for Primary Key and Clustered Index?

a) INT
b) BIGINT
c) GUID
d) SMALLINT

Query Hints:

BIG HINT POST

The clustered index is the placement order of a table’s records in memory pages. When you insert new records, then each record will be inserted into the memory page in the order it belongs. In the figure below we see another new record (Major Disarray) being inserted, in sequence, between Jonny and Rick. Since there is no room in this memory page, some records will need to shift around. The page split occurs when Irenes’ record moves to the second page. Page splits are considered very bad for performance, and there are a number of techniques to reduce, or even eliminate, the risk of page splits.

You can create a clustered index on the table on any field you choose. Sometime SQL will create a clustered index for you. Often times the field having the Primary Key makes a great candidate for the clustered index.

Additional Hints:

I have previously discussed various concepts from SQL Server Joes 2 Pros Volume 3.

Next Step:

Answer the Quiz in Contact Form in following format

  • Question
  • Answer
  • Name of the country (The contest is open for USA and India)

Bonus Winner

Leave a comment with your favorite article from the “additional hints” section and you may be eligible for surprise gift. There is no country restriction for this Bonus Contest. Do mention why you liked it any particular blog post and I will announce the winner of the same along with the main contest.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Joes 2 Pros
Previous Post
SQL SERVER – Identity Fields – Contest Win Joes 2 Pros Combo (USD 198) – Day 2 of 5
Next Post
SQL SERVER – Expanding Views – Contest Win Joes 2 Pros Combo (USD 198) – Day 4 of 5

Related Posts

20 Comments. Leave new

  • Which of the following datatype is usually NOT the best choice for Primary Key and Clustered Index?

    c) GUID

    Country: India

    Favorite Article:
    SQL Joes 2 Pros Development Series – The Clustered Index – Simple Understanding

    Reply
  • GUID is not best option for primary key anf clustered index both.it is better to break GUID-based Primary Clustered Key into two separate key – the primary (logical) key on the GUID, and the clustering (ordering) key on a separate INT IDENTITY(1,1) column. In fact it is better to have guid datatype as alternate key.GUID fill ratio for index page is terrible.

    Reply
    • Question: Which of the following datatype is usually NOT the best choice for Primary Key and Clustered Index?

      Answer: c) GUID

      Country: INDIA

      Reply
  • Usually GUID is not the best choice for Primary Key and Clustered Index.

    Reply
  • Which of the following datatype is usually NOT the best choice for Primary Key and Clustered Index?

    Ans:- c).GUID

    Additional Hints:

    SQL Joes 2 Pros Development Series – Geography Data Type – Calculating Distance Between Two Points on the Earth

    This article is related with spatial data i really interested in working with spatial data as i’m GIS developer using Spatial Database Engine (SDE) and the scenario with excellent presentation.

    Reply
  • Ans : c) GUID

    The Index data sorting is difficulty on GUID Column.

    Reply
  • Clustered Index is very detailed explained in
    SQL Joes 2 Pros Development Series – The Clustered Index – Simple Understanding.So i would prefer this as my favorite article

    Reply
  • C ) GUID

    country: india

    Reply
  • Hi Pinal,
    GUID would not be a good candidate for clustered index since it is a wide data type, clustered indexes are preferred to small,narrow,unique and ever increasing(preferably in order to avoid fragmentation).

    Country: USA
    Name: Ramdas Narayanan

    Reply
  • Question: Which of the following datatype is usually NOT the best choice for Primary Key and Clustered Index?

    Answer: c) GUID

    Country: USA

    Reply
  • Question: Which of the following datatype is usually NOT the best choice for Primary Key and Clustered Index?

    Answer: c) GUID
    Country: INDIA

    Reply
    • Question: Which of the following datatype is usually NOT the best choice for Primary Key and Clustered Index?

      Answer: c) GUID
      Country: INDIA

      Favourite article:
      SQL Joes 2 Pros Development Series – Data Row Space Usage and NULL Storage

      Reply
  • Nikunj Nandaniya
    August 9, 2012 10:58 am

    Which of the following datatype is usually NOT the best choice for Primary Key and Clustered Index?
    Answer:- c) GUID
    Country:- India

    Reply
  • P.Anish Shenoy
    August 10, 2012 1:25 pm

    Hi Sir,

    SQL Joes 2 Pros Development Series – Geography Data Type – Calculating Distance Between Two Points on the Earth

    is one of the best post that I loved trying out.

    The demonstration of the same in the Microsoft TECHED was an eye catcher.
    That Ram was actually right in calculating the shortest distance to lanka… :)

    Reply
  • Hi Pinal,
    I liked your blog post
    SQL Joes 2 Pros Development Series – Geography Data Type – Calculating Distance Between Two Points on the Earth

    In this blog Geography datatype explained very well and it will help me in future if I need to implement some solution using Geography datatype.

    Best Regards,
    S Kumar

    Reply
  • Kalyanasundaram.K
    August 13, 2012 8:06 pm

    Hi Pinal,

    In this additional HInts section, i am most liked link is below :
    SQL Joes 2 Pros Development Series – Geography Data Type – Calculating Distance Between Two Points on the Earth

    Reason : To know the new thing available in SQL, implemeting this to know the accurate reading between different locations. To avoid improper datatypes for this calculation.

    Reply
  • Uday Bhoopalam
    August 14, 2012 2:43 am

    Hello Pinal,
    Answer C: GUID. It is a bad idea to use columns defined as GUID datatype for a Primay key or a clustered index

    Country: USA

    Reply
  • Which of the following datatype is usually NOT the best choice for Primary Key and Clustered Index?
    Ans : GUID

    Reply
  • Which of the following datatype is usually NOT the best choice for Primary Key and Clustered Index?

    c) GUID

    Country: India

    Additional Hints:

    SQL Joes 2 Pros Development Series – The Clustered Index – Simple Understanding

    Reply
  • BIGINT and GUID are not a best choice for Primary key and Clustered Index.

    Reply

Leave a Reply