Viewing 15 posts - 31 through 45 (of 46 total)
A most unsurprising answer. Two options were effectively identical - so both had to be wrong. Another one sounded somewhat far-fetched. So, only the simplest - and correct - option...
July 3, 2017 at 1:48 am
Permissions
--------------------------------------------------------------------------------
User must have VIEW SERVER STATE permission to access information from the sys.dm_exec_background_job_queue dynamic management view.
KILL STATS JOB permissions default to the members of the sysadmin and processadmin fixed database...
January 10, 2017 at 2:56 am
https://www.amazon.com/Entry-Guards-2007-2016-Wrangler-Door-Blue/product-reviews/B01HD2TLD4
put me on right track! - But getting of the beaten track can be fun, as I gather Grant will agree.
A Subaru man myself.
/morten
December 28, 2016 at 1:35 am
Agree, - but along a general line of reasoning, I think a catch all option like 'None of the above' is easy to add - but dangerous - since it...
September 29, 2016 at 5:06 am
I think 'None of these queries' is correct.
(i) Table has Score, queries reference TestScore => Error
(ii) Even option 3 produces '9', not '9.0'
/morten
September 29, 2016 at 12:12 am
Que..?
Will there be a sequel to elaborate on the funny part? Anyway, Lucky to get the 7 ponts...
September 5, 2016 at 3:22 am
Really interesting - and by testing out, I both learned something and got it right.
Still, my preferred answer would be simply "Yes, it Works". - You input a row to...
July 14, 2016 at 1:28 am
https://www.pythian.com/blog/sql-server-statistics-maintenance-and-best-practices/
is another reference on this.
June 15, 2016 at 1:27 am
I have not tried it out. However,
http://jasonbrimhall.info/2014/05/23/can-you-partition-a-temporary-table/
...states that partitioning is possible!?
April 6, 2016 at 5:57 am
Phew.., I got the two points for the answer - but can't say I got the point of the question, even reading the outline. - Lucky though, to keep my...
January 13, 2016 at 2:00 am
Dooooh! Picked the right one, plus guessed wrong for the wrong "right" answer, picked #3.
December 30, 2015 at 2:41 am
Correct answer:
4
Explanation:
All of the rows are returned, as all have "coffee" as a word with a space after the word in the...
October 28, 2015 at 1:54 am
I voted, and still vote, for CURRENT_TIMESTAMP as there are no parantheses.
October 23, 2015 at 6:48 am
Viewing 15 posts - 31 through 45 (of 46 total)