Forum Replies Created

Viewing 15 posts - 22,516 through 22,530 (of 49,552 total)

  • RE: order of criteria in where clause changes query palan

    Adi Cohn-120898 (11/4/2011)

    Lowell (11/4/2011)

    A couple of Grant Fitychey's presentations he did on execution plans might be relevant;

    as i remember it, the key to look for is the property "Reason For...

    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

    November 4, 2011 at 8:42 am

    #1403280

  • RE: SQL crash - debug help needed

    OLDCHAPPY (11/4/2011)

    yeah i know, but i was trying to avoid going through MS support. :crazy:

    Then download the windows debugger and open up the trace files. I hope you're up...

    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

    November 4, 2011 at 8:22 am

    #1403260

  • RE: How can we find a particular process id to belong which instance ?.

    Joy Smith San (11/4/2011)

    can you pls give me the proper command ?. Sorry... I know I should have googled..

    Are you looking for the SQL process ID that connections to 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

    November 4, 2011 at 5:26 am

    #1403149

  • RE: How can we find a particular process id to belong which instance ?.

    As in the windows process ID? Errorlog.

    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

    November 4, 2011 at 4:29 am

    #1403133

  • RE: SQL Server maximum server memory setting and tempdb behaviour

    There isn't a correlation. If tempDB became huge, some query or queries needed a lot of TempDB space.

    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

    November 4, 2011 at 4:04 am

    #1403125

  • RE: SQL SERVER ALL LOGS

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1200377-146-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

    November 4, 2011 at 2:56 am

    #1403113

  • RE: How we can Improve the Performance of a Query WIthout creating Indexes

    If it's a table scan, there's probably an index missing. Speak with the DBA about getting the necessary indexes added.

    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

    November 4, 2011 at 2:56 am

    #1403111

  • RE: offline database back

    Do you mean an offline backup? If so, SQL doesn't do offline backups, all it's backups are done online with the DB accessible and users working.

    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

    November 4, 2011 at 2:55 am

    #1403110

  • RE: Index corrupted in table

    GilaMonster (11/2/2011)

    Please run the following and post the full and complete results:

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

    Got a clean backup?

    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

    November 4, 2011 at 2:52 am

    #1403109

  • RE: user mappings getting messed up when I restore a database to integration server

    You left out 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

    November 3, 2011 at 3:23 pm

    #1402961

  • RE: Are the posted questions getting worse?

    GSquared (11/3/2011)

    I just found a stored procedure from my predecessor at my current job, and it just kind of made my jaw drop in the elegant simplicity of it's complete...

    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

    November 3, 2011 at 3:10 pm

    #1402955

  • RE: Help! DB running out of space

    Yes. Run a once-off shrink of just the file that now has the free space, preferably run it with TRUNCATEONLY.

    If you only run the shrink with TRUNCATEONLY, you won't need...

    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

    November 3, 2011 at 11:31 am

    #1402817

  • RE: Are the posted questions getting worse?

    SQLRNNR (11/3/2011)

    GilaMonster (11/3/2011)

    Brandie Tarvin (11/3/2011)

    GilaMonster (9/29/2011)

    Wooooooooot!!!!!!!!!!!!!!!!!!

    2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here

    http://www.sqlservercentral.com/articles/books/76296/

    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

    November 3, 2011 at 11:24 am

    #1402815

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/3/2011)

    GilaMonster (9/29/2011)

    Wooooooooot!!!!!!!!!!!!!!!!!!

    2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here

    http://www.sqlservercentral.com/articles/books/76296/

    And why is...

    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

    November 3, 2011 at 11:10 am

    #1402802

  • RE: How to troubleshoot really high memory waits?

    None of those are memory-related.

    SOS_Scheduler_yield suggests you've got a lot of queries that use a lot of CPU, possible optimisation opportunities.

    All three of the waits you got from waiting tasks...

    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

    November 3, 2011 at 10:21 am

    #1402761

Viewing 15 posts - 22,516 through 22,530 (of 49,552 total)