Forum Replies Created

Viewing 15 posts - 35,296 through 35,310 (of 49,552 total)

  • RE: How Does SQL Reuse Data Pages?

    amoericke (12/14/2009)

    I’ve got a database that is logging customer activity (24x7 environment), and is retaining 7 days of data. There is a delete that runs nightly, deleting the oldest...

    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 15, 2009 at 2:29 am

    #1092392

  • RE: Where's My Additional Free Space ?

    Partially. Pre-SQL 2008 a heap can't be rebuilt except by creating a cluster on it. A heap can still have the 10% avg usage of pages if the rows deleted...

    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 15, 2009 at 2:13 am

    #1092388

  • RE: Have to use force recompile to get the SP to use indexes

    I don't think this is a stats problem. If it was, the proc would have run slow everywhere. Slow from some places and fast from others is not a symptom...

    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 15, 2009 at 2:08 am

    #1092387

  • RE: Dbcc Checkdb error

    Eswin (12/14/2009)

    The server didn't go offline also was not restarted i checked the logs.

    Then there was some kind of network glitch between the client and server. The error is 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

    December 15, 2009 at 2:04 am

    #1092386

  • RE: Update ntext subquery

    Why the subquery at all?

    UPDATE SomeTable SET Column = TextColumn

    FROM SomeTable INNER JOIN OtherTable ON <join condition here>

    WHERE OtherID = @ID

    AND WHERE SomeID = 1 --...

    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 14, 2009 at 2:54 pm

    #1092240

  • RE: Got Cache?

    myplace2sell (12/14/2009)

    Now getting to the hash join in this query...is it avoidable?

    Should you be trying to avoid it with the row counts that you mentioned?

    http://sqlinthewild.co.za/index.php/2009/11/24/the-most-optimal-join-type/

    If the row counts were...

    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 14, 2009 at 2:51 pm

    #1092238

  • RE: Error in code

    Don't understand your question. It's a scalar function that takes 3 parameters and returns a value.

    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 14, 2009 at 1:08 pm

    #1092189

  • RE: Error in code

    Paste it into a management studio query window and do a syntax check. That should give you a message saying what's wrong and on what line.

    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 14, 2009 at 12:11 pm

    #1092151

  • RE: Logical Column for record existing in 2nd table

    bkeahl (12/14/2009)

    I guess I'll write code that builds the field list based on the source database so it can dynamically build the select fields list and use Group By ......

    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 14, 2009 at 11:54 am

    #1092134

  • RE: Rebuilding indexes online isn't working?

    Consequences of turning auto-shrink off - improved performance. Read the following, and then read the two blog posts that it links to (at the bottom)

    http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/

    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 14, 2009 at 11:52 am

    #1092132

  • RE: Where's My Additional Free Space ?

    homebrew01 (12/14/2009)

    Would rebuilding actually increase space in the data files ?

    It may well do. Say those deletes have been spread out over the table. You may have large portions 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

    December 14, 2009 at 11:51 am

    #1092129

  • RE: Logical Column for record existing in 2nd table

    Firstly you shouldn't be using select *, no matter the number of columns. You're risking the app possibly breaking if a column is added in the future. Just specify...

    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 14, 2009 at 9:42 am

    #1092060

  • RE: Where's My Additional Free Space ?

    Have you rebuilt all the indexes on the tables that rows were deleted from?

    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 14, 2009 at 9:32 am

    #1092054

  • RE: Have to use force recompile to get the SP to use indexes

    one-1016367 (12/14/2009)

    I'd be happy to share them - but again, how is that relevant when the indexes are working just fine when the SP are run manually, and were also...

    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 14, 2009 at 9:31 am

    #1092053

  • RE: Have to use force recompile to get the SP to use indexes

    sql_lock (12/14/2009)

    Also make sure that your stats job is after the index job.. Had company that ran the stats before..

    Doesn't matter if it's before or after, unless it's doing 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

    December 14, 2009 at 9:27 am

    #1092047

Viewing 15 posts - 35,296 through 35,310 (of 49,552 total)