Forum Replies Created

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

  • RE: Full back up failed

    george sibbald (10/4/2010)

    Error 112 in the error log

    You know, it's sad when we know OS error codes off by heart....

    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

    October 5, 2010 at 6:04 am

    #1231608

  • RE: dynamic query creation

    EXEC (@sSQL)

    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

    October 5, 2010 at 5:31 am

    #1231593

  • RE: Opimize SQL query

    Execution plan please?

    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

    October 5, 2010 at 4:08 am

    #1231559

  • RE: Thoughts on the Wisdom of this approach?

    John Mitchell-245523 (10/5/2010)

    I suppose what it means is that, since the WHERE clause is being supplied as a parameter to the stored procedure, we could end up with too many...

    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

    October 5, 2010 at 3:10 am

    #1231532

  • RE: Decrease Query execution time.

    Please post query, 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

    October 5, 2010 at 2:58 am

    #1231528

  • RE: Thoughts on the Wisdom of this approach?

    John Mitchell-245523 (10/5/2010)

    (3) Performance. It's more likely that execution plans will not be cached for queries executed through dynamic SQL, or that inappropriate plans will be re-used.

    The dynamic SQL...

    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

    October 5, 2010 at 2:52 am

    #1231521

  • RE: TRIGGER: UPDATE, DELETE or INSERT?

    IF EXISTS (SELECT 1 FROM inserted)

    IF EXISTS (SELECT 1 FROM deleted)

    PRINT 'Is Update'

    ELSE

    PRINT 'Is Insert'

    ELSE

    PRINT...

    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

    October 5, 2010 at 2:16 am

    #1231508

  • RE: Clustered Indexes

    Christian Buettner-167247 (10/5/2010)

    What you have left out here, is the fact that rows are indeed sorted in physical order accross pages.

    So if you have 2 records on one page,...

    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

    October 5, 2010 at 2:09 am

    #1231505

  • RE: Refresh table using Trigger

    Please post table definitions, sample data and expected results as per http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    October 5, 2010 at 1:53 am

    #1231498

  • RE: Thoughts on the Wisdom of this approach?

    Two words: SQL Injection

    Seriously, if you're thinking of doing this don't bother with the stored proc and generate the ad-hoc SQL from the front end.

    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

    October 5, 2010 at 1:41 am

    #1231494

  • RE: Simple Recovery model

    free_mascot (10/5/2010)

    If simple recovery is set than transaction log truncated after each transaction commits

    It is not truncated on commit, it is truncated on checkpoint.

    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

    October 5, 2010 at 1:34 am

    #1231491

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (10/4/2010)

    GilaMonster (10/4/2010)

    Craig Farrell (10/4/2010)

    Alvin Ramard (10/4/2010)

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping...

    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

    October 4, 2010 at 10:21 pm

    #1231451

  • RE: Are the posted questions getting worse?

    Craig Farrell (10/4/2010)

    Alvin Ramard (10/4/2010)

    GilaMonster (10/4/2010)

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

    The...

    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

    October 4, 2010 at 3:42 pm

    #1231340

  • RE: Are the posted questions getting worse?

    Chad Crawford (10/4/2010)

    Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just one DVD with select sessions...

    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

    October 4, 2010 at 3:36 pm

    #1231327

  • RE: Are the posted questions getting worse?

    I'm not sure I got the order of operation there correct. Do you check that it's the correct DB before or after dropping it?

    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

    October 4, 2010 at 3:25 pm

    #1231317

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