Forum Replies Created

Viewing 15 posts - 24,946 through 24,960 (of 49,552 total)

  • RE: How can i check with exsistence of data in partiton.

    If you know the details of the partition, query sys.partitions and check the row count.

    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

    July 12, 2011 at 2:12 pm

    #1351875

  • RE: Question to execution plans and memory consumption

    Yes, the count will be the same. You have to fix the mis-matched lengths from the app, not from SQL. If this is nHibernate there is a setting somewhere (I...

    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

    July 12, 2011 at 2:08 pm

    #1351872

  • RE: sql server 2008 queries with intermittent poor performance

    I've heard, but not 100% sure...

    DBCC statements.

    Need to test and confirm that. Will do so, sometime.

    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

    July 12, 2011 at 2:07 pm

    #1351869

  • RE: sql server 2008 queries with intermittent poor performance

    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/

    Ignore the 'good enough plan' stuff. It's a mile deeper than where you are now.

    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

    July 12, 2011 at 8:42 am

    #1351630

  • RE: delete without commit

    kramaswamy (7/12/2011)

    If for whatever reason an error occurs in the statements being executed inside the transaction block, the ROLLBACK statement will never be reached, which means the transaction will 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

    July 12, 2011 at 8:11 am

    #1351599

  • RE: log ship

    If you're doing log shipping then the log backups done by the log shipping MUST be the only ones you do. If you take other log backups that aren't shipped,...

    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

    July 12, 2011 at 8:10 am

    #1351597

  • RE: sql server 2008 queries with intermittent poor performance

    Ninja's_RGR'us (7/12/2011)

    I've read a really good article on paging but I can't find it atm, Gail??

    Paul White's articles here (don't have link handy)

    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

    July 12, 2011 at 7:57 am

    #1351586

  • RE: high memory utilisation

    shilpa.shankar87 (7/12/2011)

    then how i can overcome this problem?

    Why is it a problem?

    SQL uses a lot of memory. That's how it's designed. It uses memory to cache data to avoid 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

    July 12, 2011 at 6:44 am

    #1351532

  • RE: sql server 2008 queries with intermittent poor performance

    Ninja's_RGR'us (7/12/2011)

    Wow awesome info.

    Just out of curiosity. Are you comming from oltp or olap for this conclusion?

    Yes. Optimiser behaves the same way. OLAP (being more complex queries) are more...

    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

    July 12, 2011 at 6:43 am

    #1351531

  • RE: high memory utilisation

    Syed Jahanzaib Bin hassan (7/12/2011)

    First of all check the pages life in memory with the help of mentioned query,if this value less than 300 then you have a memory pressure...

    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

    July 12, 2011 at 6:33 am

    #1351523

  • RE: sql server 2008 queries with intermittent poor performance

    Ninja's_RGR'us (7/12/2011)

    What I've found is that if I can remove the "warning" completely then I never-ish have cases where perf is unstable.

    My thinking is that if on the best scenario...

    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

    July 12, 2011 at 6:21 am

    #1351519

  • RE: sql server 2008 queries with intermittent poor performance

    Ninja's_RGR'us (7/12/2011)

    Good Enough Plan Found (not awefull but better if you don't have this warning)

    That's not a warning. It's saying that the optimiser stopped because it had found a good...

    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

    July 12, 2011 at 5:52 am

    #1351502

  • RE: Nested SQL statement

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    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

    July 12, 2011 at 4:38 am

    #1351482

  • RE: Question to execution plans and memory consumption

    Consider turning on 'optimise for ad-hoc queries'

    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

    July 12, 2011 at 2:39 am

    #1351463

  • RE: A Little Interviewing Advice

    TravisDBA (7/11/2011)

    Lee San (7/10/2011)

    I am a newbie in database administration, as much as I try to be honest about what I know/don't know, this is when I couldn't get 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

    July 12, 2011 at 2:25 am

    #1351457

Viewing 15 posts - 24,946 through 24,960 (of 49,552 total)