Forum Replies Created

Viewing 15 posts - 21,841 through 21,855 (of 49,552 total)

  • RE: Transaction Log on its own disk. How to...and performance gains. Please help.

    dale.schwabjr (12/8/2011)

    1. Would it have better performance putting the transaction log on a single drive or Raid1...assuming backups were not a concern.

    Maybe.

    2. What type of performance gains could I expect...

    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

    December 8, 2011 at 11:24 am

    #1418850

  • RE: corrupt going from 2000 to 2008

    There isn't an article that I know of...

    Can you run DBCC CheckCatalog on the SQL 2000 database and post the full and complete results.

    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

    December 8, 2011 at 11:16 am

    #1418846

  • RE: Any suggestion when batch requests reaches about 1000/sec, ?

    Why do you want to?

    What is it about 1000 batch requests/sec that troubles 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

    December 8, 2011 at 10:01 am

    #1418804

  • RE: Transaction Log on its own disk. How to...and performance gains. Please help.

    Start with this. http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Guessing, or flailing around is going to take lots of time for little gain. It may be that the logs are a bottleneck, it may be that...

    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

    December 8, 2011 at 9:50 am

    #1418791

  • RE: SELECT - LIKE %

    Spaces, like char. They're only a factor when using LIKE. = ignores trailing spaces, LIKE doesn't (it is documented)

    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

    December 8, 2011 at 9:44 am

    #1418787

  • RE: Testing Queries, OPTION(RECOMPILE) and TOP %

    Stefan Krzywicki (12/8/2011)

    GilaMonster (12/8/2011)

    Can you post the plans?

    RECOMPILE means that the plans will never be cached and hence will have to be recreated on each execution. Grant has a blog...

    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

    December 8, 2011 at 9:35 am

    #1418771

  • RE: Plain English Translation of Index Question

    Let's take an example to be absolutely clear.

    CREATE INDEX idx_Test ON SomeTable (ColA);

    SELECT ColA FROM SomeTable;

    SELECT ColB FROM SomeTable WHERE ColA = 137;

    The given index is covering for the first...

    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

    December 8, 2011 at 9:29 am

    #1418765

  • RE: Testing Queries, OPTION(RECOMPILE) and TOP %

    Can you post the plans?

    RECOMPILE means that the plans will never be cached and hence will have to be recreated on each execution. Grant has a blog post on that.

    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

    December 8, 2011 at 8:57 am

    #1418741

  • RE: SQL Server Best Practices to develop a standard base for all sql servers. Suggestions please!

    The other setting that must be changed is the server max memory. 2TB is ridiculous and asking for trouble unless you have a server with more than 2TB of memory.

    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

    December 8, 2011 at 5:10 am

    #1418607

  • RE: Temp Table Vs Table Variable

    Grant Fritchey (12/8/2011)

    With a permanent table, I have to make clean up a part of some explicit transaction at some point.

    And have a process to handle cases where due...

    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

    December 8, 2011 at 4:52 am

    #1418604

  • RE: Temp Table Vs Table Variable

    julian.fletcher (12/8/2011)

    If we can't avoid tempdb bottlenecks by getting more files and / or drives (because we don't own or have any say about the servers), doesn't this tip 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

    December 8, 2011 at 4:50 am

    #1418602

  • RE: Temp Table Vs Table Variable

    julian.fletcher (12/8/2011)

    Would anybody like to outline the pros and cons of using a real table instead of a temporary table or a table variable? Surely SQL is better at managing...

    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

    December 8, 2011 at 3:04 am

    #1418552

  • RE: temporary tables or table variable for this context ?

    anthony.green (12/8/2011)

    SQL doesnt actually create multiple tables called #temp, it creates a table with a name like the following #h35gddave4, you should be able to see some under TempDB -->...

    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

    December 8, 2011 at 3:02 am

    #1418550

  • RE: Moving to a SAN, but the sizing concept doesn't sound right....

    Whoever designed that is making the standard mistake of specing for space, not performance. Grab a copy of 'Troubleshooting SQL Server' by Jonathan Kehayias and check out chapter 2 where...

    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

    December 8, 2011 at 2:57 am

    #1418547

  • RE: corrupt going from 2000 to 2008

    The reason that CheckDB on SQL 2000 came back clean is that SQL 2000 CheckDB doesn't run CheckCatalog. SQL 2008 does.

    Do you have a backup/copy from SQL 2000? From before...

    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

    December 8, 2011 at 2:53 am

    #1418546

Viewing 15 posts - 21,841 through 21,855 (of 49,552 total)