Rather suprised at the number of incorrect answers. Would have thought that the percent correct would be closer to 100 percent.

At 7:15 AM

Correct answers: ...

Nice question on the basics

[rant]

Unfortunately the cited documentation does not support the correct answer.

A better supporting document/respected DBA is this blog posting by Steve...

I read this

Note that some index types may require additional attributes to be specified; this does not invalidate them for the context of this question. Only index types that...

Hugo Kornelis (8/28/2012)

---

I've raised a documentation bug for this issue: https://connect.microsoft.com/SQLServer/feedback/details/759944/documentation-of-isdate-function-incorrect

Hugo thanks - went and voted as a bug that I could reproduce, now I wish all would do the...

Nice basic question to start the week... Thanks

Am suprised / astonished at the number of individuals who missed this fundamental question.

Correct answers: 27% (4)

Incorrect answers: 73%...

Go here

http://www.microsoft.com/en-us/download/details.aspx?id=11455

it is a free download of the upgrade advisor .. get it, run it and then if you have problems come on back and post your questions

Oh my .. had to shake the cobwebs out of my brain cells to remember this one.

But a very good question - never hurts to refresh the basics.

What is your setting for sp_autostats ?

from the help file

Displays or changes the automatic statistics update option, AUTO_UPDATE_STATISTICS, for an index, a statistics object, a table, or an indexed...

Nice question .. good to be reminded of the fundamentals / basic stuff ..

Thanks

Have you checked on the many posting here on SSC for keeping XML data ? Suggest that it might be worth your while to check those and then make...

To give you a tool to educate yourself with .. purchase the DEVELOPER EDITION of SQL Server 2012, from AMAZON.COM

http://www.amazon.com/s/ref=nb_sb_ss_i_0_15?url=search-alias%3Daps&field-keywords=sql+server+developer+edition+2012&sprefix=sql+server+deve%2Caps%2C353 for a price of $43.99

Then until you learn enough...

You will improve the chance of someone providing you with a tested answer if you help them help you.

To do this please click on the first link in my signature...

Steve Jones - SSC Editor (8/20/2012)

---

bitbucket-25253 (8/19/2012)

QODs using images instead of easily cut and paste text have now been excluded from being published, I would propose to the powers that...

When creating #temptable why do you include...

The highlights added by this poster and NOT in the OP original request.

Golfer22 (8/19/2012)

---

Where would I find a list of T-SQL commands and reserved words?

The number of reserved words and...