Forum Replies Created

Viewing 15 posts - 13,966 through 13,980 (of 49,552 total)

  • RE: Always on Secondry database backup plan & Recovering.

    ratheesh4sql (3/9/2013)

    here the problem is i can schedule copy only full backup and log backup on secondary server...

    Using this is it possible....?

    Have you tried? If so, does it not work?...

    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

    March 9, 2013 at 10:24 am

    #1595247

  • RE: In Need of some expert query help

    Personally I don't think there's anything there that requires distinct, I suspect that distinct is there out of habit, probably the same for the nolocks.

    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

    March 9, 2013 at 9:58 am

    #1595244

  • RE: Always on Secondry database backup plan & Recovering.

    Suggestions for what?

    How you recover with the backup strategy you listed is pretty easy, restore latest full backup, restore all log backups.

    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

    March 9, 2013 at 9:56 am

    #1595243

  • RE: Enabling Always On Option in sql server 2012

    Just an additional comment, any form of HA/DR between SQL instances of different versions (log shipping, mirroring, etc) is generally not a good idea. The only way it can work...

    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

    March 9, 2013 at 8:29 am

    #1595235

  • RE: Looping without cursor not updating properly

    Just worth noting, a while loop is just as much a cursor as an explicitly defined cursor. It just doesn't have the keyword. It's still a loop, it's still processing...

    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

    March 9, 2013 at 5:51 am

    #1595212

  • RE: sequencial insert

    Ok... so what's the question/problem?

    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

    March 9, 2013 at 5:36 am

    #1595209

  • RE: In Need of some expert query help

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

    You can start fixing the query by removing the nolock, unless you don't mind the query returning incorrect data...

    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

    March 9, 2013 at 5:33 am

    #1595208

  • RE: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW

    Is the SSIS service installed on that machine?

    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

    March 9, 2013 at 3:47 am

    #1595205

  • RE: partition_id VS. hobt_id

    Lynn Pettis (3/8/2013)

    GilaMonster (3/8/2013)

    opc.three (3/8/2013)

    GilaMonster (3/3/2013)

    They were added as separate columns to support a feature that was planned, partially added to SQL 2005 and later scrapped.

    You know I am curious...

    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

    March 8, 2013 at 9:33 am

    #1595032

  • RE: Performance Tuning Question

    MyDoggieJessie (3/8/2013)

    Try something like this (Disclaimer: may contain syntax errors :-D);WITH DATA AS (

    SELECT

    'All' [OpID],

    'All Ops' [Op Name],

    1 [Number],

    1 AS Cnt

    UNION ALL

    SELECT

    LEFT(Oprid, 4) [OpID],

    Name + ' (' + LEFT(Oprid, 4)...

    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

    March 8, 2013 at 8:59 am

    #1595010

  • RE: Not consuming memory

    Using Task Manager to monitor SQL's memory usage?

    32 bit 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

    March 8, 2013 at 8:51 am

    #1595000

  • RE: partition_id VS. hobt_id

    opc.three (3/8/2013)

    GilaMonster (3/3/2013)

    They were added as separate columns to support a feature that was planned, partially added to SQL 2005 and later scrapped.

    You know I am curious about these kinds...

    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

    March 8, 2013 at 8:46 am

    #1594998

  • RE: Database Timeouts : Error -2 Severity 11

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

    Also note that you need to tune your workload, not your individual queries.

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    March 8, 2013 at 5:45 am

    #1594928

  • RE: Page life expectancy diving to sub-10 on a 128 GB server

    allmhuran (3/8/2013)

    GilaMonster (3/8/2013)

    allmhuran (3/8/2013)

    GilaMonster (3/8/2013)

    sys.dm_os_wait_stats

    Most of those are meaningless waits, background processes that are supposed to be waiting. That list says nothing of any value.

    Yep, that's kinda the point I'm...

    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

    March 8, 2013 at 5:32 am

    #1594926

  • RE: Page life expectancy diving to sub-10 on a 128 GB server

    allmhuran (3/8/2013)

    GilaMonster (3/8/2013)

    sys.dm_os_wait_stats

    Most of those are meaningless waits, background processes that are supposed to be waiting. That list says nothing of any value.

    Yep, that's kinda the point I'm making by...

    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

    March 8, 2013 at 5:20 am

    #1594923

Viewing 15 posts - 13,966 through 13,980 (of 49,552 total)