Forum Replies Created

Viewing 15 posts - 26,206 through 26,220 (of 49,552 total)

  • RE: Auto growth for Transaction Log

    kr.nithin (5/11/2011)

    On 7th the Data File size was 12 GB & the Log size rocketed from 4 MB to 2.7 GB. I Detached the database & moved the Log File....

    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

    May 11, 2011 at 2:02 am

    #1322780

  • RE: My database was set to 10% autogrow & now it's HUGE. Can I fix this?

    aehoward73 (5/10/2011)

    I have a database that was about 845MB 4 months ago. It was set to Autogrow at 10%. The database is up to 11GB now. I've...

    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

    May 10, 2011 at 11:48 pm

    #1322751

  • RE: Are the posted questions getting worse?

    ALZDBA (5/10/2011)

    Steve Jones - SSC Editor (5/10/2011)

    Just rated some sessions for the PASS Summit. This has to be one of the poorest implementations of a rating tool I've seen, but...

    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

    May 10, 2011 at 2:15 pm

    #1322634

  • RE: Auto growth for Transaction Log

    JoeS 3024 (5/10/2011)

    Curious about this topic. Say you have a 40GB DB file. Would it ever be realistic to have say a 20GB log file?

    Sure. It depends...

    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

    May 10, 2011 at 2:14 pm

    #1322633

  • RE: Are the posted questions getting worse?

    Kiara (5/10/2011)

    Second on the rating tool issue... it keeps making me log back in after selecting a speaker. *mutter* Still, I'll happily mark my favorite people to learn 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

    May 10, 2011 at 1:02 pm

    #1322604

  • RE: SQL Server 2005

    Brandie Tarvin (5/10/2011)

    I caught the BCM, GAM, and SGAM in the very first link I visited. I'll need to check out the other two, though, because I didn't see anything...

    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

    May 10, 2011 at 11:43 am

    #1322559

  • RE: Accessing Password enabled Excel report

    chaudharyabhijit (5/10/2011)

    Thanks for the link. There should be a feature to be able to delete a post.

    There used to be. We had too many cases of people deleting their posts...

    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

    May 10, 2011 at 11:43 am

    #1322558

  • RE: Are the posted questions getting worse?

    GSquared (5/10/2011)

    Gail, sent four devs to your Catch-All Queries blog entry today. Thanks again for writing that. They all got it and one even got excited about it....

    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

    May 10, 2011 at 11:42 am

    #1322555

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (5/10/2011)

    Just rated some sessions for the PASS Summit. This has to be one of the poorest implementations of a rating tool I've seen, but 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

    May 10, 2011 at 11:41 am

    #1322554

  • RE: How to script a profiler trace in SQL Server 2008

    Open the profiler GUI, set up the trace you want (against a dev server). Run. Stop. File -> Export -> Script trace definition.

    Open the resultant file in Management Studio 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

    May 10, 2011 at 11:28 am

    #1322542

  • RE: SQL Server 2005

    Brandie Tarvin (5/10/2011)

    Gail, I want to thank you for that search term. I learned a few things I didn't know.

    Cool. Here's a couple more if you're bored and curious.

    ML (minimally...

    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

    May 10, 2011 at 11:28 am

    #1322541

  • RE: Accessing Password enabled Excel report

    No further replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1106276-364-1.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

    May 10, 2011 at 11:26 am

    #1322530

  • RE: Added a Clustered index On ID cloumn but not ordered? Why?

    thinknight (5/10/2011)

    I added Clustered Index to ID Cloumn on Testtable, after adding index records did not ordered iwth ID cloumn, Why?

    Because SQL does not guarantee the order of data unless...

    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

    May 10, 2011 at 11:24 am

    #1322528

  • RE: Order of Tables in a Query

    terrykzncs (5/10/2011)

    Correct me if I am wrong, but I have read that SQL will process the FROM clause followed by the SELECT clause and then the WHERE clause, so having...

    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

    May 10, 2011 at 11:02 am

    #1322505

  • RE: My sql server does not start

    Is the OS 32 bit or 64 bit?

    What's the total memory?

    How much is available?

    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

    May 10, 2011 at 7:50 am

    #1322312

Viewing 15 posts - 26,206 through 26,220 (of 49,552 total)