SQL SERVER – Win a Book a Day – Contest Rules – Day 0 of 35

Learning is an extremely important part of life. From the first step, everybody progresses in life and learns something new. Earlier this year, SQLAuthority.com had a month-long series on SQL Server Interview Questions. It was extremely popular series, and I received a lot of encouraging comments. While I compiled the received feedback, one important feedback was the need of good basic learning.  The reason for writing this series is to present a proper learning structure rather than a simple blog post.

And here is your chance to win some exciting gifts - For the next 35 days, every day at SQLAuthority.com, we are giving away two SQL Books.

Yes, you heard it right! – TWO SQL Server books are given away every single day for the next 35 days. No eBooks, but books in hard-copy, which you can carry around and read at your convenience. You can win these books very easily.

You just have to take a simple quiz at the end of the each blog post, and we will ship two SQL Books every day to a random winner.

Rules:

Please leave your answer in the comment section below with correct option, explanation, and your country of residence.
Every day one winner will be announced from United States.
Every day one winner will be announced from India.
The valid answer must contain country of residence of the answerer.
Please check my facebook page for winners’ names and correct answers.
The contest is open till the next blog post shows up at http://blog.sqlauthority.com, which is next day GTM+2.5.
There is no purchase required and winner will be selected RANDOMLY.

Questions – Book 1

Q 1) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Wildcard Basics Recap – Day 1 of 35

Q 2) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Wildcard – Querying Special Characters – Day 2 of 35

Q 3) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Finding Apostrophes in String and Text – Day 3 of 35

Q 4) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy – Day 4 of 35

Q 5) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Finding un-matching Records – Day 5 of 35

Q 6) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Row Constructors – Day 6 of 35

Q 7) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Dirty Records and Table Hints – Day 7 of 35

Questions – Book 2

Q 8) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Many to Many Relationships – Day 8 of 35

Q 9) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Overriding Identity Fields – Tricks and Tips of Identity Fields – Day 9 of 35

Q 10) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Aggregates with the Over Clause – Day 10 of 35

Q 11) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Advanced Aggregates with the Over Clause – Day 11 of 35

Q 12) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Ranking Functions – RANK( ), DENSE_RANK( ), and ROW_NUMBER( ) – Day 12 of 35

Q 13) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Ranking Functions – Advanced NTILE in Detail – Day 13 of 35

Q 14) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Output Clause in Simple Examples – Day 14 of 35

Questions – Book 3

Q 15) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Data Row Space Usage and NULL Storage – Day 15 of 35

Q 16) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – System and Time Data Types – Day 16 of 35

Q 17) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Sparse Data and Space Used by Sparse Data – Day 17 of 35

Q 18) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Geography Data Type – Calculating Distance Between Two Points on the Earth – Day 18 of 35

Q 19) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – The Clustered Index – Simple Understanding – Day 19 of 35

Q 20) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Introduction to Page Split – Day 20 of 35

Q 21) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – All about SQL Statistics – Day 21 of 35

Question – Book 4

Q 22) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – All about SQL Constraints – Day 22 of 35

Q 23) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Introduction to Views – Day 23 of 35

Q 24) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Easy Introduction to CHECK Options – Day 24 of 35

Q 25) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Table-Valued Store Procedure Parameters – Day 25 of 35

Q 26) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Table-Valued Functions – Day 26 of 35

Q 27) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – SQL Server Error Messages – Day 27 of 35

Q 28) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Structured Error Handling – Day 28 of 35

Question – Book 5

Q 29) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – What is XML? – Day 29 of 35

Q 30) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – What is XML? – Day 30 of 35

Q 31) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Using Root With Auto XML Mode – Day 31 of 35

Q 32) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Using Root With Auto XML Mode – Day 32 of 35

Q 33) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Shredding XML – Day 33 of 35

Q 34) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Preparing XML in Memory – Day 34 of 35

Q 35) SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – OpenXML Options – Day 35 of 35

Reference:  Pinal Dave (http://blog.SQLAuthority.com)

About these ads

12 thoughts on “SQL SERVER – Win a Book a Day – Contest Rules – Day 0 of 35

  1. you said that a PDF file will be avaliable at the end of last month for SQL Server Interview Questions.
    can you say when it will be published.
    by the way I love your blog, to bad the I cant participate in the game because i’m not from india or the United states.

  2. Q 1: Answer : SELECT * FROM Customer WHERE Firstname = ‘[a-m]% ‘
    Q 2:Answer :SELECT * FROM [Grant] WHERE GrantName = ‘_%[_]%_ ‘
    Q 3:Answer :SELECT * FROM Employee WHERE Firstname like ‘%’% ‘

    ShaliniMeyyappan From India

  3. SELECT * FROM Employee
    WHERE Firstname like ‘%”%’ this is the only query which return all first names that have an apostrophe anywhere in the name

    rest of the queries will either give syntax error or wont give all first names that have an apostrophe anywhere in the name

    I am Sen Thomas from India, Bangalore

    Sincere Thanks Pinal

  4. Thanks Pinal for taking the time to do this. Like your post today about using Insert Select instead of Cursors, I have to admit I didn’t have a sql or programming background coming out of school and had to learn a lot as I went. I’ve had my share of bad code and there are still some things I do not understand well.

    Every so often I run into this over() and partion() code in some of our more complicated queries and never quite got what it was doing even after doing some quick digging on the internet. I must say that after the last two days of questions I realized it is really simple and totally makes sense the way you have it explained. Thanks so much!

  5. Pingback: SQLAuthority News – Pluralsight Giving Away Free Subscription to Quiz Participants Journey to SQLAuthority

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s