Forum Replies Created

Viewing 15 posts - 43,231 through 43,245 (of 49,552 total)

  • RE: Stored Procedure speed versus Select Statement

    Patrick Russell (11/10/2008)

    I guess I hadn't thought of that. I actually try to stay away from dynamic sql. I always thought there where sql injection issues with it. Only use...

    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 10, 2008 at 10:43 am

    #896434

  • RE: Help controlling transaction log growth needed

    Marker (11/10/2008)

    This DB is in Full Recovery mode. I'm backing up the Transaction Logs every 4 hours. If there was a catastrophic failure, 1 hour of lost data...

    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 10, 2008 at 10:33 am

    #896428

  • RE: Help controlling transaction log growth needed

    Lynn Pettis (11/10/2008)

    Knowing Gail, I'm sure she has the queries you need to identify long running transactions. I'd have to do some research for those.

    On SQL 2000 the only...

    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 10, 2008 at 10:29 am

    #896423

  • RE: The Reverse Optimization Challenge #1

    Garadin (11/10/2008)

    Correlated subqueries CAN (I believe the optimizer sometimes converts them to joins / derived tables for you) be run Row by Row, which is very slow.

    More correctly,...

    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 10, 2008 at 10:28 am

    #896419

  • RE: Tempdb is full due to crappy procedure!!!

    Loner (11/10/2008)

    The tempdb is set to automatically grow by 10% and unrestricted file grow.

    What's the initial size? If you're using TempDB heavily, it must be changed from the default (2MB?)...

    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 10, 2008 at 9:46 am

    #896386

  • RE: Help controlling transaction log growth needed

    Firstly, read through these two articles:

    http://www.sqlservercentral.com/articles/64582/

    http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/

    What recovery model is this DB in (I'm guessing full) and how often do you backup the transaction log?

    What is considered acceptable data loss 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 10, 2008 at 9:38 am

    #896383

  • RE: execution plan not using correct index

    Can you post the query, the table with index definitions and the execution plan without the hint (saved as a .sqlplan file, zipped and attached to your 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 10, 2008 at 9:27 am

    #896375

  • RE: How will restore database from mysql to SQL Server 2008

    See if you can open the file in a text editor. I've seen MySQL 'backups' in the past been nothing more than scripts to create and populate the DB. They...

    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 10, 2008 at 9:26 am

    #896374

  • RE: The Reverse Optimization Challenge #1

    TheSQLGuru (11/10/2008)

    Gail, your index choices and join choices were 'too good'! 🙂

    I was trying to see how many sorts I could get in a single query. Answer,...

    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 10, 2008 at 9:15 am

    #896372

  • RE: Stored Procedure speed versus Select Statement

    Seeing the code makes all the difference. It's not technically parameter sniffing.

    That form of catch-all query does not perform well. Firstly the optimiser can't make accurate predictions with all of...

    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 10, 2008 at 9:13 am

    #896370

  • RE: Stored Procedure speed versus Select Statement

    Patrick Russell (11/7/2008)

    I have some procedures which i consider simple (joining 5 tables) returning mayby 10-12 records/with 3 columns. When I run the app, and it accesses this particular procedure...

    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 10, 2008 at 6:22 am

    #896254

  • RE: Re: Interpreting results for SET STATISTICS IO

    Any indexes on those tables?

    Is the distinct necessary?

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

    #896250

  • RE: Storing Negative Numbers

    Do they have a reason for this decision?

    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 10, 2008 at 6:18 am

    #896247

  • RE: "primary key" in Table Variable

    China Satya Rao T (11/10/2008)

    In the execution plan, the cost of table variable population is 0.1%

    In the main query, cost of table scan on table variable is 0%

    The cost of...

    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 10, 2008 at 6:09 am

    #896244

  • RE: How to keep one billion records in one table ?

    Why does it have to be a single table?

    Have you considered table partitioning (SQL 2005 feature)

    How wide are the rows?

    What indexes do you have and what are the common 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

    November 10, 2008 at 3:16 am

    #896169

Viewing 15 posts - 43,231 through 43,245 (of 49,552 total)