Forum Replies Created

Viewing 15 posts - 16,771 through 16,785 (of 49,552 total)

  • Reply To: How to upload images in a post in SQLSERVERCENTRAL forum ?

    Take the link to the attachment and wrap it in tags (without spaces)

    Quote this post to see how I did it.

    • This reply was modified 7 years, 5 months ago by Gail Shaw.
    • This reply was modified 6 years, 2 months ago by Dave Convery.

    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

    September 5, 2012 at 4:38 pm

    #1534177

  • RE: Latest service pack - how to be alerted

    Stick this into your favourite RSS reader http://blogs.msdn.com/b/sqlreleaseservices/rss.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

    September 5, 2012 at 2:12 pm

    #1534123

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (9/5/2012)

    jcrawf02 (9/5/2012)

    bitbucket-25253 (9/5/2012)

    Time for me to toot my own horn ... braging HECK yes.

    My 73rd QOD has been scheduled for 06 Sep 2012 - 07 Sep 2012

    Should 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

    September 5, 2012 at 1:14 pm

    #1534082

  • RE: Restarting One Database Not Entire Server

    Edit: nm, can't read apparently...

    What do you get when you try to kill the spid?

    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

    September 5, 2012 at 7:58 am

    #1533825

  • RE: Rollback Script

    Junglee_George (9/5/2012)

    Yes Gail, rollback script is what I need.

    Can you pls help on this? Just a sample SQl Script will do.

    Thanks

    Sure.

    ALTER PROCEDURE <the name of the procedure here> (< 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

    September 5, 2012 at 7:11 am

    #1533785

  • RE: Rollback Script

    Rolling the change back is probably a good idea...

    See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

    The rollback script will just be an ALTER PROCEDURE with the definition of the proc prior to the change that...

    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

    September 5, 2012 at 3:12 am

    #1533684

  • RE: Restore Faills

    Add more drive space to server B.

    Seriously, if the DB is growing, it's growing. Unless you decide to archive data and hence free up space in the data file, 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

    September 5, 2012 at 2:03 am

    #1533663

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (9/4/2012)

    OK, not my day. Not sure how to break the news here that this person is in way, way, over their head.

    http://www.sqlservercentral.com/Forums/Topic1353224-2799-2.aspx#bm1354093

    No kidding. And he's...

    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

    September 4, 2012 at 2:16 pm

    #1533507

  • RE: Plan Caching in Sql Server 2005

    "75% of visible target memory from 0-4GB + 10% of visible target memory from 4Gb-64GB + 5% of visible target memory > 64GB"

    So you have 180 GB of memory...

    75% 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

    September 4, 2012 at 2:14 pm

    #1533506

  • RE: Why is INSERT INTO faster than INSERT

    There's no difference whether or not the INTO keyword is specified. The very first thing that happens as part of query execution is parsing and once that's done, the query...

    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

    September 4, 2012 at 11:45 am

    #1533433

  • RE: can any one plz tell me what is indexing for example ?

    sivajii (9/4/2012)

    i dont even no what is index

    Did you read the articles I linked?

    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

    September 4, 2012 at 11:36 am

    #1533427

  • RE: Change Reovery Model During Backup

    If you want to reduce the log size, just use ShrinkFile and shrink the log. Shrinking the data file does require log space, so if a little counter to your...

    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

    September 4, 2012 at 11:08 am

    #1533413

  • RE: Why is my transaction log full?

    New thread please. The discussion thread of an article is not the best place for a problem that isn't directly related to the article.

    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

    September 4, 2012 at 10:15 am

    #1533381

  • RE: Ridiculous

    chrisn-585491 (9/4/2012)

    I've not seen this behavior at the SQL Server events I've gone to

    I have. No where near as bad, and only twice out of many conferences, 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

    September 4, 2012 at 9:29 am

    #1533356

  • RE: Why is my transaction log full?

    As you identified, the cause of the log being full is the active backup. The checkDB errors are all a result of the log being full, nothing else.

    You need to...

    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

    September 4, 2012 at 9:06 am

    #1533344

Viewing 15 posts - 16,771 through 16,785 (of 49,552 total)