Forum Replies Created

Viewing 15 posts - 39,646 through 39,660 (of 49,552 total)

  • RE: Effect of Truncate on Indexes

    Patelbhai (4/19/2009)

    Do I need to rebuild indexes on these tables after re-loading the data?

    Depends how you're reloading. If it's in one operation, unlikely. If you're doing lots of small...

    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

    April 19, 2009 at 12:02 pm

    #980375

  • RE: Page split

    If a row has to be inserted onto a page that's full, SQL splits the page. It allocates a new page, moves half of the rows on the full page...

    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

    April 19, 2009 at 5:54 am

    #980335

  • RE: Information on Datafile - Urgently.

    Is google down?

    http://msdn.microsoft.com/en-us/library/ms179316.aspx

    http://msdn.microsoft.com/en-us/library/ms187087.aspx

    If you don't understand what they're saying, or if you still have questions after reading them, please ask.

    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

    April 19, 2009 at 3:54 am

    #980328

  • RE: Are the posted questions getting worse?

    Perfect. Thanks.

    Can I use that pic in the article I'm busy with (with credit)?

    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

    April 18, 2009 at 3:31 pm

    #980262

  • RE: Are the posted questions getting worse?

    Anyone got SQL 2000? More specifically Query Analyser?

    If so, can you please get me a screen shot of the following.

    Run the following:

    SET STATISTICS PROFILE ON

    GO

    SELECT * FROM sysobjects

    There will be...

    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

    April 18, 2009 at 3:02 pm

    #980256

  • RE: Are the posted questions getting worse?

    Thanks.

    Can you (and anyone else interested) PM me an email address I can use? Doc is currently in Word 2007 format

    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

    April 18, 2009 at 2:14 pm

    #980252

  • RE: Are the posted questions getting worse?

    Anyone willing to review a short article? "How to post performance problems"

    I should be finished with it tomorrow.

    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

    April 18, 2009 at 1:47 pm

    #980247

  • RE: Can we revert back to previous compatibility mode???

    klnsuddu (4/18/2009)

    If something goes wrong after changing the compaibility to 90, can we go back to comatibility 80?

    Yes. The compatibility level just affects how T-SQL is parsed and run 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

    April 18, 2009 at 11:29 am

    #980233

  • RE: query special for totals

    Check out the PIVOT keyword in Books Online. It should do what you want.

    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

    April 18, 2009 at 11:08 am

    #980226

  • RE: interview questions

    Alvin Ramard (4/18/2009)

    Also, I've seen a few interviews cut short because the interviewee was not able to discuss items on his resume. Be prepared to discuss every item on...

    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

    April 18, 2009 at 10:03 am

    #980213

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/18/2009)

    I'd love to but he keeps hijacking threads with his "product" and I totally dislike salesmen that think by disparaging the competition their product will look better instead...

    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

    April 18, 2009 at 9:33 am

    #980207

  • RE: interview questions

    Alvin Ramard (4/18/2009)

    GilaMonster (4/18/2009)

    Order Pizza.

    That's the manager's job. My last manager did that several times. The only question she had to ask was: "What do you want on...

    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

    April 18, 2009 at 9:32 am

    #980205

  • RE: Understanding execution plan

    Check this blog series out. http://sqlinthewild.co.za/index.php/2007/08/20/reading-execution-plans/

    Grant Fritchley's written a book on reading exec plans. I don't know if it's still available for download. I'm sure he'll drop by later 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

    April 18, 2009 at 6:32 am

    #980171

  • RE: Compatibility level

    You've got SQL 2000 there, not 2005. Compatibility level 90 is SQL 2005. The highest level that you can set a SQL 2000 server to is compatibility level 80.

    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

    April 18, 2009 at 6:27 am

    #980170

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/17/2009)

    I wonder if he will be able to put 2 and 2 together and realize he is in the same bucket of slop as that second contractor I...

    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

    April 18, 2009 at 5:10 am

    #980158

Viewing 15 posts - 39,646 through 39,660 (of 49,552 total)