Forum Replies Created

Viewing 15 posts - 76 through 90 (of 583 total)

  • RE: Default schema

    Koen Verbeeck (3/31/2014)


    WTH?

    The script doesn't mention sysadmin but database owner.

    The created user doesn't have sysadmin permissions, so the table will be created using the default schema.

    Points back please!

    I find it...

  • RE: Stairway to XML: Level 1 - Introduction to XML

    Just piling own with my own Thank You. I already knew most of this from osmosis. But, it really helps to have it laid out in an organized manner.

  • RE: Indexes

    Thanks for the great question! Inspired me to do a little refresher study of indexes (and views too). Got me to working on a couple of needed views for reporting....

  • RE: Alas Poor Snapshot, I Knew Him Well

    This question is totally unrealistic - I would never eat at Chipotle. 😉 I would have been at my favorite Chinese place, or, if being bad, at my favorite Greek...

  • RE: Permitted no of bytes per row

    timwell (3/18/2014)


    When I ran the script I got the following:

    Msg 1701, Level 16, State 1, Line 1

    Creating or altering table '#cTab' failed because the minimum row size would be 16011,...

  • RE: OPENQUERY-1

    Thanks for the question, Carlo.

    Don't know which is more interesting - the option for -1 rows, or the fact that 3% selected it as their answer!

  • RE: Members of windows group

    TomThomson (3/13/2014)


    The call in the explanation doesn't give all memers of the group - members of a group G1 which is itself a member of a group G are automatically...

  • RE: T-SQL SELECT..INTO

    j.green (3/11/2014)


    free_mascot (3/11/2014)


    Yes, initially I have drafted the question straight forward but it looks very simple. Deliberately make it complicated by tricky language to make challenging.

    Usually everyone knows correct...

  • RE: View My Definition

    Had to guess, and got it right. Thanks for the question, but questions that are this subjective are deprecated in future versions of SQL Server. 😉

  • RE: REPLACE behavior

    Thanks Auke. I liked the question. Do you have more?

  • RE: Order By Column

    Nice question on an interesting topic. But agree explanation could have been better. Let's see another one Anoo.

  • RE: EXCEPT 2

    Between the rerun on the question and the constant snow, it's beginning to feel like "Groundhog Day". 😉

  • RE: DSQ

    Seemed too easy, and then I remembered it was Friday. Thanks for the question!

  • RE: Geeky Entertainment

    wodom (2/28/2014)


    For many years the only books I've longed, really longed, for someone to make movies of, are:

    Isaac Asimov's "Foundation" trilogy

    Robert Heinlein's "The Door Into Summer"

    The latter is not as...

  • RE: Startup In Single-User Mode

    Wasn't easy for me, but easy to find. And, it helped me learn something new. Thanks!

Viewing 15 posts - 76 through 90 (of 583 total)