Forum Replies Created

Viewing 15 posts - 7,321 through 7,335 (of 7,484 total)

  • RE: Keeping up with Technology

    I think it's probably impossible to manage something you know nothing about unless you have the sort of personality that can comfortably delegate real decision making power to others. ...

  • RE: Database Size

    I agree with many of the comments so far: this was not a good QOTD.

    The correct answer is that the a default create with no parameters supplied other...

  • RE: Perfect is the Enemy of Good

    I don't like the cliche. Best practise is to consider the tradeoffs and choose the course of action that will deliver the most favorable outcome. That is no...

  • RE: Perfect is the Enemy of Good

    GOC-481399 (1/19/2010)


    Be good to see an alternative article on how to maintain your standards when thrown into a (purely hypothetical of course) BI/Reporting team where:

    It can be much worse...

  • RE: SQL Server 2008 Policy-Based Management

    A very useful question. I've learned something new. Policy-based management begins to look more useful.

    But I guess MS must have changed their mind at some point but forgot to...

  • RE: SQL 2K5 - Table-Valued Parameters

    Mauve (1/15/2010)


    Lynn Pettis (1/15/2010)


    I don't read the QotD in the newsletter, I read it on SSC.

    And it is best to answer later in the day as the question is usually...

  • RE: SQL 2K5 - Table-Valued Parameters

    Kevin Gill (1/15/2010)


    To my mind, this question could/should have been moderated and edited to make it clearer.

    Even though I would have got it wrong had it actually been asking...

  • RE: The Price of SQL Server

    I guess I would be happy to see UK prices for SQL server at about £3k per socket for standard edition, and about four times that for enterprise. Last...

  • RE: Exec on Linked Server

    A good QOTD -one of the better ones.

    It's quite amusing how MS muddles its terminology in this area, though

    If you read http://msdn.microsoft.com/en-us/library/ms188332.aspx you will find the following text:-

    L. Using a...

  • RE: Why Can't We Go Backwards?

    I wonder if the feature is all that important? It seems to me to be something that would only get used very rarely, and for such infrequent use it...

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    RBarryYoung (2/10/2010)


    About 8-10 months ago while trying to help someone with a similar problem on the MSDN forums, I discovered that there is in fact a way to do this...

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Jeff Moden (5/4/2009)


    JohnG (5/4/2009)


    peter (5/4/2009)


    True, from an ADO client application. However, It doesn't work from T-SQL. I.e., You cannot consume a result set returned by a stored procedure...

  • RE: Database Snapshot and Rollback Transactions

    The Paul R blog entry is nice and clear - my mind was boggling at the original article, but as soon as I read the phrase "copy-before-write" it all clicked.

  • RE: Dynamic SQL

    Lynn Pettis (2/9/2010)


    Explain to me why you think each of the answers is wrong.

    Because each answer tries to select from a table with a particular name in an completely unspecified...

  • RE: Dynamic SQL

    Lynn Pettis (2/9/2010)


    Okay, explain to me why C, although the correct answer, is wrong.

    Becasue all the code options povide produce an error or NULL. Now if you think that...

Viewing 15 posts - 7,321 through 7,335 (of 7,484 total)