Forum Replies Created

Viewing 15 posts - 346 through 360 (of 516 total)

  • RE: GO Part 2

    kaspencer (9/13/2012)


    This question is illogical in structure.

    One cannot say "Can the following script be made to run ..." and then offer the choices True and False.

    For future reference, this type...

  • RE: GO Part 2

    Nice question Kenneth...though I got it worng 🙂

    Worth learning something..Thanks!

  • RE: APPLY - 1

    Wooops....amazing question Ron!

  • RE: GO Part 1

    Lucky me...not fallen prey by the trap GO 5 😀

    Nice Question though..

  • RE: Using Sparse Columns and Sparse Column Sets

    Nice question Wayne..

    The only exception when insert will fail is when one tries to insert in a column (col1/col2/col3) and TblColumnSet (COLUMN_SET) in one go

    Cheers 🙂

  • RE: Outer join not working correctly

    ChrisM@Work (9/4/2012)


    Having read the spec properly - thanks Lokesh Vij - here's attempt #2:

    You are welcome Chris 🙂

  • RE: Outer join not working correctly

    cmc_dermo (9/3/2012)


    I have a query where i would like to show all items from the items table even if no data exists for that item in the stock table.

    Just a...

  • RE: can any one plz tell me what is indexing for example ?

    Not sure what your question is...but if you want to know what index is, where to use them and what benefits they offer....check the following link

    http://www.sqlservercentral.com/stairway/72399/

  • RE: Basic Design Question

    ChrisM@Work (9/4/2012)


    Without any prior experience of this type of data, I'd be tempted to add a time dimension. That would give you team history, the team as it is right...

  • RE: Table Variable

    Good Question to refresh our basics 🙂

  • RE: Labor Day 2012

    Thank you for the easy question and the easy 7 marks....free of labor on labor day 🙂

  • RE: when Changing DB Default SET options.

    Sorry to say. It is not clear to me (pretty sure to the others as well), else you could have got the answer.

  • RE: Querying EAV data

    RBarryYoung (8/31/2012)


    This is basically the price you pay for the flexibility that EAV brings.

    And developers love EAV because its seems like a dream during the Design and initial Development phases,...

  • RE: Querying EAV data

    CELKO (8/31/2012)


    You are screwed; EAV is 10 orders of magnitude worse than even a bad non-normalized schema. Yes, you have to assembly each column with joins and all yiou can...

  • RE: Index types 2

    Thanks for the great question Hugo!

    Kept me researching to figure out the correct answer. In the end, I followed the proecss of eliminitation 🙂

    Very sure that you must have spent...

Viewing 15 posts - 346 through 360 (of 516 total)