Forum Replies Created

Viewing 15 posts - 21,031 through 21,045 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    LutzM (1/14/2012)

    There's one thing I wonder about: the "Test Pass guarantee" (https://partner.microsoft.com/40161629).

    I usually question any source that'll guarantee someone will pass a test without knowing anything about that person at...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 14, 2012 at 9:41 am

    #1433706

  • RE: Max and Min Server Memmory

    SQL Kiwi (1/14/2012)

    GilaMonster (1/14/2012)

    385 GB of memory? That's a huge server.

    It's one of those new ones with 3x128GB and 1x1GB RAM chips installed :laugh:

    😀

    Either that was a mistype or it's...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 14, 2012 at 9:39 am

    #1433704

  • RE: Select Query - need optimization

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 14, 2012 at 6:52 am

    #1433688

  • RE: Running Full and Transaction-Log Backups Concurrently - Any Implications for Database Recovery?

    Marios Philippopoulos (1/12/2012)

    What happens if a previous log backup, lb0, had started at 9:45 pm (ie. prior to start of the full backup) and completed at 10:05 pm (ie. after...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 14, 2012 at 6:51 am

    #1433687

  • RE: Max and Min Server Memmory

    385 GB of memory? That's a huge server.

    Have a look at chapter 4 of this book, it discusses memory and gives some rough suggestions and reasons for the settings...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 14, 2012 at 6:47 am

    #1433686

  • RE: Incorrect syntax near 'sp_dboption'.

    Dev (1/14/2012)

    Per BOL EXEC or EXECUTE to run a stored procedure is optional.

    No, it's not. From the link you posted:

    You do not have to specify the EXECUTE keyword...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 14, 2012 at 4:16 am

    #1433671

  • RE: Are the posted questions getting worse?

    Jeff Moden (1/13/2012)

    It would appear that MS finding out about someone using such a site and revoking their cert because of it has been and certainly is nothing but a...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 14, 2012 at 3:50 am

    #1433668

  • RE: How can you write a view with Variables in a subquery?

    View no, in-line table-valued function, yes. Views can't have variables of any form.

    Also, btw... http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2012 at 4:18 pm

    #1433596

  • RE: How to keep a plan in cache

    Gianluca Sartori (1/13/2012)

    Once refactored the view to a PIVOT, the execution time dropped to 30 ms (or was it 300 ms?? I don't remember) and I was never able to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2012 at 4:16 pm

    #1433595

  • RE: How to keep a plan in cache

    azdzn (1/13/2012)

    - if the plan is stable and using 'USE PLAN' has the same effect as stopping the optimiser from compiling on each run

    it still looks like a good...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2012 at 4:12 pm

    #1433594

  • RE: How to keep a plan in cache

    Yes, use plan forces the optimiser to use a specific plan form (it does allow a little leeway), but that is not Tom's problem, he want to stop the optimiser...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2012 at 3:48 pm

    #1433582

  • RE: How to keep a plan in cache

    No. UsePlan does not disable the optimiser and KeepFixedPlan is either for schema invalidation or statisics invalidation (forget which and not checking now)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2012 at 3:27 pm

    #1433573

  • RE: Precedence and Logical Operators

    GSquared (1/13/2012)

    And, let me guess, no documentation on the business-logic that created that?

    Logic? Documentation? Really, what makes you think either of those exists in most companies? 😉

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2012 at 2:07 pm

    #1433520

  • RE: I am new to triggers

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1235923-1292-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2012 at 1:53 pm

    #1433510

  • RE: Precedence and Logical Operators

    Don't thank me. Redgate's SQL Prompt -> Format SQL. Don't think I would have had the patience to do it by hand.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    January 13, 2012 at 1:52 pm

    #1433508

Viewing 15 posts - 21,031 through 21,045 (of 49,552 total)