Forum Replies Created

Viewing 15 posts - 18,241 through 18,255 (of 49,552 total)

  • RE: Data File and Log File

    http://msdn.microsoft.com/en-us/library/ms189563.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

    June 6, 2012 at 2:58 am

    #1497469

  • RE: What should be the best strategy for partitioning?

    What is the reason for partitioning these tables?

    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

    June 6, 2012 at 2:56 am

    #1497466

  • RE: To get the result without using joins (not subquery)

    Why do you want to use a less-efficient mechanism? Joins are more expensive than in/exists or not in/not exists subqueries are.

    http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

    http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

    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

    June 6, 2012 at 2:56 am

    #1497465

  • RE: Are the posted questions getting worse?

    Revenant (6/5/2012)

    Nope - they know you are a safe-to-deal-with customer and they hope that you will get into minus on your checking account, and they will charge you something like...

    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

    June 6, 2012 at 2:54 am

    #1497464

  • RE: Are the posted questions getting worse?

    It's dependant on good credit ratings here and all sorts of other stuff.

    What amuses me is that I have two accounts with this bank, cheque and savings. They're offering me...

    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

    June 5, 2012 at 5:25 pm

    #1497348

  • RE: Are the posted questions getting worse?

    I love the fact that my bank keeps offering me an overdraft1 at reasonable rates, even though I have more than 5 times the overdraft amount in my account. What...

    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

    June 5, 2012 at 3:32 pm

    #1497331

  • RE: Measuring performance

    Gianluca Sartori (6/5/2012)

    GilaMonster (6/5/2012)

    Chapter 1 (and several others): http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Dang! Two recommendations in less than three minutes.

    If I had $.01 for every time I recommended this book, I would be 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

    June 5, 2012 at 3:18 pm

    #1497324

  • RE: Measuring performance

    Chapter 1 (and several others): http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

    June 5, 2012 at 2:57 pm

    #1497314

  • RE: simulating/assessing index impact

    Sergei Zarembo (6/5/2012)

    GilaMonster (6/5/2012)

    It's been possible since SQL 2000 or before, but it's undocumented and needs options that you, as a user, don't have. It's how DTA works. It creates...

    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

    June 5, 2012 at 11:58 am

    #1497248

  • RE: simulating/assessing index impact

    It's been possible since SQL 2000 or before, but it's undocumented and needs options that you, as a user, don't have. It's how DTA works. It creates hypothetical indexes 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

    June 5, 2012 at 9:47 am

    #1497149

  • RE: long running sp

    I recommend not playing with locking hints. If SQL's chosing page locks by default (which it probably would with a query that updates a fair portion of the table) then...

    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

    June 5, 2012 at 9:14 am

    #1497120

  • RE: Need to have a query which could get me the details sizes for all the tables in a prticular database

    sysindexes is deprecated, will be removed in a future version, there only for backward compat with SQL 2000 and should not be used. It can also be inaccurate about 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

    June 5, 2012 at 9:11 am

    #1497117

  • RE: Transaction Log doesn't grow!!!!

    Any time you switch from simple recovery (or create a new DB), you will need a full or diff backup to start the log chain before SQ: will start retaining...

    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

    June 5, 2012 at 9:07 am

    #1497108

  • RE: View with Parameter??

    No. Table variables only, but I strongly recommend you don't use a multi-statement table-valued function as they can be performance nightmares

    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

    June 5, 2012 at 7:57 am

    #1497056

  • RE: Is this a network speed Issue?

    Yes, for exactly the reason I wrote.

    Async Network IO waits are actually not network waits most of the time. They're waits for the client app to acknowledge the resultset, 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

    June 5, 2012 at 7:37 am

    #1497045

Viewing 15 posts - 18,241 through 18,255 (of 49,552 total)