Forum Replies Created

Viewing 15 posts - 29,266 through 29,280 (of 49,552 total)

  • RE: Work around for SQL server performance issue

    Gangadhara MS (11/21/2010)

    I have followed the same steps and found that some stored procedures having highest duration abnd IO/CPU.

    But my developer saying i can't further tune with query 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

    November 21, 2010 at 11:05 pm

    #1253581

  • RE: Work around for SQL server performance issue

    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

    November 21, 2010 at 10:48 pm

    #1253579

  • RE: Query optimization for huge tables

    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

    November 21, 2010 at 10:42 pm

    #1253578

  • RE: unable to shrink log file

    matthew.peters (11/21/2010)

    To anyone still browsing this forum. A way around shrinking a log file which wont shrink is by creating a new one and deleting the old one through moving...

    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 21, 2010 at 10:40 pm

    #1253577

  • RE: Transaction Log backup stuck rolling back

    j mills (11/8/2010)

    Have any of you seen this before and possibly know what is causing that wait?

    I've seen similar before (but a bit more complex, involving a failed autogrow 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 21, 2010 at 11:15 am

    #1253509

  • RE: Transaction Log backup stuck rolling back

    EvilDba (11/21/2010)

    When you backup tlog, SQLServer commits the transactions

    Err.. No.

    Backing up the transaction log does not commit any transactions. The only thing that commits a transaction is 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 21, 2010 at 11:12 am

    #1253508

  • RE: SQL Book

    jagirdba (11/21/2010)

    In that case you appear to have problem with your brain your self. Secondly if I was a neurosurgeon I would surely suggest a good book.

    Thanks for wasting...

    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 21, 2010 at 5:40 am

    #1253486

  • RE: Table Normalization

    Homework?

    First things first. Do you know what the requirements are for 2nd and 3rd normal forms?

    Secondly, that table is not in 1st normal form. To be in first normal form,...

    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 21, 2010 at 1:07 am

    #1253464

  • RE: Table Normalization

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1023995-145-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 21, 2010 at 1:07 am

    #1253463

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (11/20/2010)

    All this gibbering and jabbering about age -- Your are all youngsters.

    I've got a GREAT GRAND DAUGHTER born on April 2nd, 2010. As Jeff Moden once said "Ron...

    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 21, 2010 at 1:00 am

    #1253462

  • RE: SQL Book

    I'll be blunt, if you don't know the area and have an upcoming interview, a book is not going to help much.

    Relax

    Don't overstate your skills

    Don't be afraid to say '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

    November 20, 2010 at 10:22 am

    #1253412

  • RE: SQL Server 2005 in 2000 compatibility mode/turn off effects

    tcholzer (11/20/2010)

    4) what happens to existing tables and data when you turn OFF 2000 compatibility (to take advantage of varchar(max) and other stuff?

    Absolutely nothing.

    Has anyone actually done this? (Turned off...

    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 20, 2010 at 10:20 am

    #1253411

  • RE: Age-old question: Cluster on Date or ID?

    Craig Farrell (11/19/2010)

    When an operator is executed multiple times as part of the query execution, the estimated row count refers to the number of rows that the optimiser estimates will...

    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 20, 2010 at 5:01 am

    #1253390

  • RE: Are the posted questions getting worse?

    Craig Farrell (11/19/2010)

    And, well, I wasn't sure if Gail was familiar with them

    Totally lost. No idea what you're talking about.

    Aside: This is why, when I took part in the Pass...

    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 20, 2010 at 4:57 am

    #1253389

  • RE: Age-old question: Cluster on Date or ID?

    Craig Farrell (11/19/2010)

    Nice test on the seek vs. scan with lookup. I had wondered where the 0.3% number originated.

    It's not hard and fast that number. Another planned blog post...

    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 19, 2010 at 2:37 pm

    #1253324

Viewing 15 posts - 29,266 through 29,280 (of 49,552 total)