Forum Replies Created

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

  • RE: AUTO UPDATE STATISTICS

    Are they very big tables?

    With auto update stats, the stats get updated after a certain percentage of the table changed. With larger tables, it takes more changes to trigger 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

    January 30, 2007 at 11:19 am

    #686553

  • RE: The 400,000 Member Milestone

    Steve

    Tried replying to your mail on polo shirt, using email that you indicated, got user does not exist error. Is there another address I can 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

    January 28, 2007 at 10:15 pm

    #686074

  • RE: Data At Home

    Not as much as most, probably.

    The desktop machine has a 160GB and a 20GB. There's a badly damaged 200GB in there which I need to throw away.

    The laptop has...

    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

    January 25, 2007 at 11:54 pm

    #685753

  • RE: Query Efficiency

    Pretty much, though you'll have to check and make sure you get the same 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

    January 25, 2007 at 9:31 am

    #685611

  • RE: Error 17052, SQL server crashes

    Can you post parts of the stack dump? The input buffer for spid 85, the short stach dump

    Few questions...

    You said the dump is triggered by a select. Are any 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

    January 25, 2007 at 6:03 am

    #685490

  • RE: Why can''''t I do ''''create table blah as (select....''''?

    No. It has to not exist. 

    SELECT INTO creates the table and inserts the results of the select into it.

    To insert results into an existing table, you'd use INSERT INTO <table>...

    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

    January 25, 2007 at 4:26 am

    #685468

  • RE: Query Efficiency

    Subselects in the select clause are extremely inefficient. Move them out into joins and it'll be a lot better.

    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

    January 25, 2007 at 4:22 am

    #685467

  • RE: Why can''''t I do ''''create table blah as (select....''''?

    Possible, but not with that syntax. Did you check books online?

    The syntax you're looking for is

    SELECT * INTO New_Addresses FROM Addresses

    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

    January 25, 2007 at 4:19 am

    #685465

  • RE: Error 17052, SQL server crashes

    What's in the SQL errorlog just before it shuts down?

    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

    January 25, 2007 at 1:32 am

    #685436

  • RE: Error handling when using set-based processing

    I'm sure the bard is rolling in his grave right about now.

    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

    January 24, 2007 at 10:54 pm

    #685420

  • RE: changing the table reserved size

    Hmm. Very wierd

    Try rebuilding the clustered index - DBCC DBREINDEX ('Actions') - and then do an update usage. See if that has any effect.

    If not, then I'm really stumped.

    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

    January 24, 2007 at 7:16 am

    #685192

  • RE: changing the table reserved size

    Hmmm. Wierd....

    Can you run the following and post the output please

    DBCC SHOWCONTIG('<table name>')

    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

    January 24, 2007 at 6:39 am

    #685178

  • RE: changing the table reserved size

    Is it possible to change the reserved size?

    Not directly. Afaik, it's a measure of how many pages/extents are allocated to the table. Not something you can change manually.

    Is there 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

    January 24, 2007 at 6:04 am

    #685168

  • RE: Error handling when using set-based processing

    With a set-based insert, the entire insert will succeed, or will fail. It's not possible to insert the rows that are OK and ditch the others.

    If this is a common...

    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

    January 24, 2007 at 5:58 am

    #685165

  • RE: changing the table reserved size

    Have you tried rebuilding the indexes on that table since the delete? (specifically the clustered index)

    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

    January 24, 2007 at 5:39 am

    #685161

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