Viewing 15 posts - 316 through 330 (of 3,221 total)
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: ...
August 31, 2012 at 5:16 am
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...
August 30, 2012 at 9:48 pm
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...
August 30, 2012 at 7:39 am
Hugo Kornelis (8/28/2012)
Hugo thanks - went and voted as a bug that I could reproduce, now I wish all would do the...
August 28, 2012 at 5:39 am
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%...
August 26, 2012 at 6:53 am
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
August 22, 2012 at 7:55 pm
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.
August 21, 2012 at 10:02 pm
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...
August 21, 2012 at 6:28 pm
Nice question .. good to be reminded of the fundamentals / basic stuff ..
Thanks
August 20, 2012 at 8:16 pm
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...
August 20, 2012 at 6:41 pm
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...
August 20, 2012 at 6:34 pm
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...
August 20, 2012 at 12:45 pm
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...
August 20, 2012 at 8:37 am
I would like to do is "Insert into tableA select * from #temptable" but it does not allow me since tableA has identity column
When creating #temptable why do you include...
August 19, 2012 at 3:56 pm
The highlights added by this poster and NOT in the OP original request.
Golfer22 (8/19/2012)
The number of reserved words and...
August 19, 2012 at 2:50 pm
Viewing 15 posts - 316 through 330 (of 3,221 total)