Forum Replies Created

Viewing 15 posts - 24,076 through 24,090 (of 49,552 total)

  • RE: My DataBase Went to RECOVERY_PENDING State

    That state comes from a file missing or inaccessible. Find all the messages in the SQL error log relating to this database and don't try anything to it just yet...

    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

    August 19, 2011 at 7:48 am

    #1370730

  • RE: Cannot shrink log file because all logical log files are in use

    One way that I know works:

    Create a publication (transactional)

    Publish a single table

    Delete the publication.

    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

    August 19, 2011 at 7:34 am

    #1370716

  • RE: Improving performance

    a_ud (8/19/2011)

    I'll happily do all you ask for, but there's problems:

    -Don't know what an execution plan is.

    Did you read the article?

    -Too many tables, functions, a backend, a frontend,...

    For one query?

    If...

    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

    August 19, 2011 at 6:00 am

    #1370650

  • RE: Real value of TSQL Batches?

    Stamey (8/19/2011)

    As I said, others around me believe that having a "Go" between each statement in the script is going to help the transaction log to be checkpointed and emptied...

    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

    August 19, 2011 at 5:38 am

    #1370638

  • RE: Cannot shrink log file because all logical log files are in use

    http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

    August 19, 2011 at 4:19 am

    #1370614

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/18/2011)

    I've never used them. I've always used something else because they didn't use to be available. Not sure I'd actually use them, either, beccause of 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

    August 19, 2011 at 4:19 am

    #1370612

  • RE: Can I *reduce* the number of .NDF files?

    Drop, remove, what's the difference 😀

    You shouldn't need the shrink with emptyfile for TempDB.

    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

    August 18, 2011 at 3:44 pm

    #1370444

  • RE: Can I *reduce* the number of .NDF files?

    Since it's tempDB it's a little different from user databases.

    ALTER DATABASE TempDB DROP FILE ....

    Then restart SQL. The change will only be effective after a restart, until then it's just...

    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

    August 18, 2011 at 2:49 pm

    #1370417

  • RE: Row and page locks on indexes

    If you turn both off, SQL will lock at a table level every time. You may know that there will be no updates but, unless the database or filegroup is...

    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

    August 18, 2011 at 11:31 am

    #1370273

  • RE: Are the posted questions getting worse?

    I mix up 'or' and 'of' frequently. It's a pain, as spell checkers won't catch it and frequently grammar checkers don't either as the resultant sentence is correct, just not...

    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

    August 18, 2011 at 11:22 am

    #1370271

  • RE: Are the posted questions getting worse?

    If I'd been speaking out loud it would have been 'an'. I wrote quickly without speaking it, hence it went to '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

    August 18, 2011 at 11:10 am

    #1370264

  • RE: Dont flame me :)

    Try DBForums.com for MySQL questions. It wasn't too bad last time I checked

    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

    August 18, 2011 at 9:24 am

    #1370201

  • RE: Improving performance

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    August 18, 2011 at 8:43 am

    #1370167

  • RE: File Size, Space used, space left question

    A 2 litre water bottle with 500ml of water in it is still a 2 litre water bottle, it just has a lot of free space in 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

    August 18, 2011 at 8:26 am

    #1370153

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (8/18/2011)

    Well it looks like we might have an SSC party at the PASS Summit after all for those of you that are going. No deal...

    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

    August 18, 2011 at 8:12 am

    #1370144

Viewing 15 posts - 24,076 through 24,090 (of 49,552 total)