Forum Replies Created

Viewing 15 posts - 14,896 through 14,910 (of 49,552 total)

  • RE: Databases are under "Suspect" Mode

    Post the exact errors from the SQL error log (all of them), then switch the DB into Emergency mode and run

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

    and post those errors

    You...

    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 9, 2013 at 2:37 am

    #1575110

  • RE: updates on a table

    Rebuild the clustered index.

    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 8, 2013 at 1:12 pm

    #1574985

  • RE: Deadlock In SQL

    lnardozi 61862 (1/8/2013)

    Expressing them as left joins though is a MUCH faster solution which will minimize the deadlocks. It won't get rid of them completely though.

    Actually not. Left joins are...

    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 8, 2013 at 12:28 pm

    #1574975

  • RE: Deadlock In SQL

    rocky_498 (1/8/2013)

    I am dam sure about this ALL SPS/INDEX/VIEW/TRIGG/ and so on are same (Prod/Test)

    I am not talking about the *definition* of the queries. To get a deadlock on two...

    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 8, 2013 at 12:00 pm

    #1574965

  • RE: dm_exec_query_stats vs. dm_exec_procedure_stats

    Steve Malley (1/8/2013)

    Does this mean that all statements in procedure_stats are 'echoed' in query stats?

    Yes. Procedure stats is a subset, queries that are also procedures

    My intention is to gather...

    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 8, 2013 at 11:07 am

    #1574941

  • RE: blocking LCK_M_SCH_S, LCK_M_SCH_M

    rocks (1/8/2013)

    HI,

    Thanks for quick reply, I have gone through the post. so what is the best way to avoid this locks. we are using nolock hint...

    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 8, 2013 at 10:58 am

    #1574937

  • RE: Deadlock In SQL

    rocky_498 (1/8/2013)

    I am Refreshing this Database from Production to Test (Everything is same except One day old data)

    So test has exactly the same load, exactly the same queries executing as...

    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 8, 2013 at 10:55 am

    #1574934

  • RE: blocking LCK_M_SCH_S, LCK_M_SCH_M

    You can't. Sch-M is a schema modification lock. Blocks everything and is blocked by absolutely anything, including the Sch-S locks that all queries have to take. Online index rebuilds 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

    January 8, 2013 at 9:51 am

    #1574915

  • RE: Query runs with error when passed parameters

    Brandie Tarvin (1/8/2013)

    GilaMonster (1/8/2013)

    I thought you said you were calling the exact piece of code as you gave above, with the declare and set in it?

    Gail, believe it or not,...

    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 8, 2013 at 9:48 am

    #1574912

  • RE: Deadlock In SQL

    rocky_498 (1/8/2013)

    Could be Server Issue?

    No

    or still deadlock in que?

    No.

    Deadlocks occur when 2 pieces of code want the resources that the other is using. It's not a problem of one piece...

    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 8, 2013 at 9:47 am

    #1574911

  • RE: Query runs with error when passed parameters

    I thought you said you were calling the exact piece of code as you gave above, with the declare and set in 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

    January 8, 2013 at 9:22 am

    #1574891

  • RE: EXISTS vs IN vs .... COUNT?!

    GSquared (1/8/2013)

    I believe SQL Server will sometimes shortcut a "Where (select count(*) blah blah blah) > 1" into an Exists() check. But don't count on the optimizer being smarter...

    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 8, 2013 at 8:40 am

    #1574858

  • RE: MCTS to MCSA - 2008 or 2012?

    If you solely work with 2008, then I'd say get the 2008 certs. That way your experience will back up the certs. You can always upgrade them later

    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 8, 2013 at 8:33 am

    #1574855

  • RE: Index usage and RID lookup.

    Extents are just 8 contiguous pages aligned on a 64k boundary.

    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 8, 2013 at 8:16 am

    #1574846

  • RE: Are the posted questions getting worse?

    Anyone familiar with SAP query generator?

    http://www.sqlservercentral.com/Forums/Topic1404204-391-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 8, 2013 at 7:35 am

    #1574818

Viewing 15 posts - 14,896 through 14,910 (of 49,552 total)