Forum Replies Created

Viewing 15 posts - 39,211 through 39,225 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    RBarryYoung (5/9/2009)

    Moreover, I am now completely convinced that the empty string feature is no accidental side-effect, cleverly exploited by Microsoft's customers, but rather intentional functionality explicitly added 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

    May 10, 2009 at 3:33 am

    #991751

  • RE: Performing backup but DBCC errors

    Just run it with no parameters in the database in question.

    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

    May 10, 2009 at 3:31 am

    #991750

  • RE: Performing backup but DBCC errors

    Please run the following on that database and post the full results.

    DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

    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

    May 9, 2009 at 2:04 pm

    #991678

  • RE: Are there issues with ONLINE INDEX REBUILD

    Florian Reischl (5/9/2009)

    He told me that there are issues with online rebuilds and checkpoints which may cause that the transaction log will not be cleared after backup. The only...

    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

    May 9, 2009 at 2:03 pm

    #991677

  • RE: Understanding Execution Plans

    WayneS (5/8/2009)

    So, if this is done, why is it still doing an index scan and rid lookup instead of an index seek? What am I missing?

    Which operator in which...

    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

    May 9, 2009 at 2:36 am

    #991581

  • RE: move Master database from the 2000 to 2005 SQL server

    Don't try. The system databases shouldn't be moved from one version to another. It's really asking for problems.

    Script out whatever it is in the master database that you want (logins,...

    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

    May 9, 2009 at 2:12 am

    #991576

  • RE: What is the best way to dynamically define columns in the WHERE clause and avoid dynamic SQL

    Jeffrey Williams (5/8/2009)

    If you really cannot use dynamic SQL - the other options are to force the stored procedure to recompile each time it is called, or you can force...

    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

    May 9, 2009 at 2:06 am

    #991574

  • RE: What is the best way to dynamically define columns in the WHERE clause and avoid dynamic SQL

    RBarryYoung (5/8/2009)

    This happens because ANY fixed plan chosen ahead of time will be wrong most of the time. The obvious fix is to not pick the execution plan (and...

    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

    May 8, 2009 at 1:50 pm

    #991436

  • RE: How can I get an Execution Plan into a table column?

    Marios Philippopoulos (5/8/2009)

    It would have been great if SQL Server stored that extra run-time info as well, the same way it stores the "estimated" data.

    It does with some, in 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

    May 8, 2009 at 1:47 pm

    #991434

  • RE: How can I get an Execution Plan into a table column?

    Lowell (5/8/2009)

    for those of us little fish trying to follow along, i get an error on "plan_handle"---i'm running SQL2005 SP2 on my dev machine, I'll upgrade and see if ...

    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

    May 8, 2009 at 9:50 am

    #991239

  • RE: Checking Up on Developers

    Frank Buchan (5/8/2009)

    I would love to see a real, simple, and developer-focused article or two about indexes. Drop all the terminology possible, and just shape an understanding so the developers...

    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

    May 8, 2009 at 9:32 am

    #991222

  • RE: How can I get an Execution Plan into a table column?

    Just note that you've got an estimated plan there (or more correctly, an execution plan without run time information).

    I can't thing offhand of another way. If it was 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

    May 8, 2009 at 9:27 am

    #991213

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/8/2009)

    Speaking of which, Gail, I had a couple of UBD moments with your article

    UBD?

    Thanks, I'll send it to Steve over the weekend.

    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

    May 8, 2009 at 9:27 am

    #991212

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/8/2009)

    Well, nothing wrong with a Masters by course work, that was my MA as well. Trust me, though, there was plenty of research work involved outside of...

    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

    May 8, 2009 at 9:23 am

    #991210

  • RE: Is 50,000 transactions a minute a lot

    Are you seeing IO bottlenecks? (perfmon, physical disk:avg sec/read, physical disk:avg sec/write, physical disk:% idle time)

    First things first, before you go looking for hardware. Fix the queries, fix the indexes....

    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

    May 8, 2009 at 9:11 am

    #991189

Viewing 15 posts - 39,211 through 39,225 (of 49,552 total)