Forum Replies Created

Viewing 15 posts - 4,096 through 4,110 (of 7,484 total)

  • RE: Are the posted questions getting worse?

    HowardW (10/2/2012)


    Anyone else eagerly awaiting this?

    Not me. Banks is over-rated and over-priced. I'll wait until I can pick up a (paper) copy for £2 or less in a...

  • RE: View Records That Are Associated With a User Table

    Look at the example beginning with this text:

    the Report

    In order to test the report, login as a particular user or launch Internet Explorer by right clicking on it, selecting Run...

  • RE: Regular expression in T-sql

    XMLSQLNinja (9/27/2012)


    CELKO (9/15/2012)


    ...And then there is a high cost of CLR. .

    Hogwash. There is nothing "high cost" about a well written CLR.

    Avoid this kludge if you can.

    There's nothing...

  • RE: APPLY - 2

    Nice question.

    Glad I looked at it after breakfast, not before - without fuel I would probably have calculated 2+2+2+1+1+2 = 7 or something equally silly. Don'y you feel a bit...

  • RE: View Records That Are Associated With a User Table

    I don't understand why you think the article you reference doesn't solve the problem. It certainly allows each user to be associated with (and therefor see data concerning) one...

  • RE: O(n) , O(n log n), O(n^2)

    karthikeyan-444867 (9/28/2012)


    Experts,

    is there any solution available for "Mass concatenate" in SQL 2008 OR SQL 2012?

    People have already referred to teh "for xml" method, which is O(n) so for larg enough...

  • RE: O(n) , O(n log n), O(n^2)

    GilaMonster (6/8/2009)


    karthikeyan (6/8/2009)


    1) O(n) means ?

    2) O(n^2) means ?

    3) O(n log n) means ?

    Surely you covered the Big O notation for algorithmic (time) complexity at university? It's a fundamental of...

  • RE: IDENTITY INSERT

    bitbucket-25253 (9/27/2012)


    Unpleasantly surprised at the high number of incorrect answers:

    Correct answers: 49% (196)

    Incorrect answers: 51% (207)

    Total attempts: ...

  • RE: IDENTITY INSERT

    Nice question - interesting collection of syntax errors.

  • RE: Extended Events II

    Good question. Putting the things in pairs is quite a nice way of making some though neccessary in what might otherwise have been too easy.

  • RE: Are the posted questions getting worse?

    ChrisM@Work (9/28/2012)


    Koen Verbeeck (9/28/2012)


    laurie-789651 (9/28/2012)


    Koen Verbeeck (9/28/2012)


    Grant Fritchey (9/27/2012)


    THREADIZENS!

    Who is going to make it to any of the SQL in the City events coming up in the next week+?

    If you...

  • RE: How to increase indexes performance for fast queries results

    MSzI (9/27/2012)


    Hello,

    First off all I would suggest to create a unique clustered index, on the column that is a primary key.

    In Your case this would be the ROWID column....

  • RE: A Really Good Job

    I'm in agreement with mdaughtree's comment above.

    But, lt's be a bit more specific than that: Steve's editorial seems to say that a job with low pay, or long hours,...

  • RE: Trade-offs

    Frank W Fulton Jr (9/26/2012)


    I agree. You can pick two, one from colum A, B or C but you can't get all three; period.

    No, you can trade off between time,...

  • RE: Stack Ranking

    Eric M Russell (7/23/2012)


    Regardless of that formal methodology is used for appraisals, I expect that most managers mentally "stack rank" the employees in their department anyhow. What we're talking about...

Viewing 15 posts - 4,096 through 4,110 (of 7,484 total)