Forum Replies Created

Viewing 15 posts - 31 through 45 (of 235 total)

  • RE: Relational Model versus XML

    Raghavendra Mudugal (1/23/2013)

    Koen Verbeeck (1/23/2013)

    I'd like to see the performance of the XML solution.

    Also, I would think the structure of your website is known, so a relational model is preferred.

    Curious...


    See, understand, learn, try, use efficient
    © Dr.Plch

    January 24, 2013 at 12:39 am

    #1580384

  • RE: Finding New Years Eve

    Happy New Year


    See, understand, learn, try, use efficient
    © Dr.Plch

    January 1, 2013 at 12:48 am

    #1572653

  • RE: Mirrors

    Koen Verbeeck (12/11/2012)

    Are you sure a log backup is needed? Quoting from BOL:

    Typically, you need to take at least one log backup on the principal database. However, a log backup...


    See, understand, learn, try, use efficient
    © Dr.Plch

    December 11, 2012 at 2:12 am

    #1567295

  • RE: Which Statement will execute sucessfully

    Lokesh Vij (12/7/2012)

    What would happen, if the current user is mapped to any one of the two schema's by default? Last statement would always throw an error!!

    As this option was...


    See, understand, learn, try, use efficient
    © Dr.Plch

    December 7, 2012 at 12:26 am

    #1566472

  • RE: Queries

    Hugo Kornelis (11/28/2012)

    Dave62 (11/28/2012)

    I came across this odd behavior in SSMS the other day when I was looking at estimated execution plans and thought I'd share it with the community.

    Sorry...


    See, understand, learn, try, use efficient
    © Dr.Plch

    November 28, 2012 at 7:50 am

    #1563162

  • RE: Queries

    Koen Verbeeck (11/28/2012)

    The only correct answer is 0.

    There are 8 statements in the estimated execution plan, but no queries.

    From BOL:

    A query is a request for data that is stored in...


    See, understand, learn, try, use efficient
    © Dr.Plch

    November 28, 2012 at 5:40 am

    #1563052

  • RE: Thanksgiving 2012

    Happy Thanksgiving.

    COUNT carefully the turkeys!


    See, understand, learn, try, use efficient
    © Dr.Plch

    November 22, 2012 at 4:42 am

    #1561592

  • RE: character ordering

    Ross.M (11/1/2012)

    honza.mf (11/1/2012)

    Ross.M (11/1/2012)

    ... however for the sake of understanding string comparisons, we have no use for knowing how many characters are between 0 and Z, we just need to...


    See, understand, learn, try, use efficient
    © Dr.Plch

    November 1, 2012 at 6:05 am

    #1554966

  • RE: character ordering

    Ross.M (11/1/2012)

    ... however for the sake of understanding string comparisons, we have no use for knowing how many characters are between 0 and Z, we just need to know the...


    See, understand, learn, try, use efficient
    © Dr.Plch

    November 1, 2012 at 5:14 am

    #1554945

  • RE: character ordering

    derek.colley (11/1/2012)

    I'm afraid this question was just too obscure for me. It's a good question, sure, but why would I need to know this or reference it in any...


    See, understand, learn, try, use efficient
    © Dr.Plch

    November 1, 2012 at 3:35 am

    #1554903

  • RE: character ordering

    My first estimate was something near 75 (10 digits, 26 uppercase, 26 lowercase) but then I remembered the accents and found a table.


    See, understand, learn, try, use efficient
    © Dr.Plch

    November 1, 2012 at 2:36 am

    #1554888

  • RE: While loop

    Toreador (10/23/2012)

    honza.mf (10/12/2012)

    Right. Who cares?

    The bank of course, so they have transactions properly implemented (we must hope).

    In the UK at least, such processes work entirely in the bank's favour. Transaction...


    See, understand, learn, try, use efficient
    © Dr.Plch

    October 23, 2012 at 5:23 am

    #1551832

  • RE: While loop

    WayneS (10/11/2012)

    honza.mf (10/11/2012)

    Hugo Kornelis (10/11/2012)

    Transactions (that's what "TRAN" is short for) are primarily used to ensure that a series of statements that form a single unit of work are either...


    See, understand, learn, try, use efficient
    © Dr.Plch

    October 12, 2012 at 7:52 am

    #1548648

  • RE: While loop

    Hugo Kornelis (10/11/2012)

    Transactions (that's what "TRAN" is short for) are primarily used to ensure that a series of statements that form a single unit of work are either completely executed,...


    See, understand, learn, try, use efficient
    © Dr.Plch

    October 11, 2012 at 4:10 am

    #1547984

  • RE: While loop

    Hugo Kornelis (10/10/2012)

    A.jafari (10/9/2012)

    Please illustrate diffrent between "Begin Catch" And "Try Except"

    You can read about TRY ... CATCH here: http://msdn.microsoft.com/en-us/library/ms175976.aspx

    In T-SQL, "Try Except" is...


    See, understand, learn, try, use efficient
    © Dr.Plch

    October 10, 2012 at 11:44 am

    #1547771

Viewing 15 posts - 31 through 45 (of 235 total)