Forum Replies Created

Viewing 15 posts - 22,606 through 22,620 (of 49,552 total)

  • RE: I need help on Log File Problem

    Maybe start by reading these:

    http://www.sqlservercentral.com/articles/Administration/75461/

    http://www.sqlservercentral.com/articles/64582/

    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

    October 31, 2011 at 1:44 pm

    #1401284

  • RE: HELP! Disk Full. Error message: log_reuse_wait_desc

    EdA ROC (10/31/2011)

    Yes, RAID Drives - What I meant by safeguard is that it's a level of protection above a single drive system. Hence, like a physical safeguard device with...

    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

    October 31, 2011 at 1:44 pm

    #1401283

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (10/31/2011)

    We all knew this was coming....

    :w00t: :hehe: 😀

    Worth noting, the top 3 are all within 100 posts of each other, surprising with the total post counts involved.

    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

    October 31, 2011 at 1:35 pm

    #1401278

  • RE: Are the posted questions getting worse?

    SQLRNNR (10/31/2011)

    L' Eomot Inversé (10/31/2011)

    Thomw (10/31/2011)

    Thanks! I noticed that the thread has 'drifted' after my post and have edited to at least not look too lame LOL

    Rather than...

    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

    October 31, 2011 at 1:31 pm

    #1401275

  • RE: Reindex failed primary file group not enough space

    sqlfriends (10/31/2011)

    If it needs 120%, does it mean at least I need to allocate 4.5 gb space to the data file, total at least 14.5gb?

    Maybe. You haven't said how big...

    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

    October 31, 2011 at 1:28 pm

    #1401272

  • RE: DBCC SHOWCONTIG

    anthony.green (10/31/2011)

    Take a look through sys.dm_db_missing_index_details for a list of indexes which SQL thinks you would benefit from

    No, please no. Missing index DMV is for nonclustered indexes. Stuff in there...

    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

    October 31, 2011 at 1:26 pm

    #1401271

  • RE: first attempt at automated backup plan

    Is a domain controller online and accessible?

    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

    October 31, 2011 at 1:20 pm

    #1401269

  • RE: HELP! Disk Full. Error message: log_reuse_wait_desc

    EdA ROC (10/31/2011)

    Gail - Thanks for the alert. I hadn't thought about this since we created the db. Our ERP vendor's tech guy suggested SIMPLE at the time. There are...

    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

    October 31, 2011 at 9:47 am

    #1401159

  • RE: DBCC SHOWCONTIG

    anthony.green (10/31/2011)

    most of the documentation says if fragmentation is less than 30% then a reorganize is the way to go and if its above 30% then rebuild

    Except this is 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

    October 31, 2011 at 9:42 am

    #1401153

  • RE: DBCC SHOWCONTIG

    You've got a heap here, so it can't really be rebuilt. That's for indexes.

    Don't use showcontig, it's deprecated and has been for 6 years. Use sys.dm_db_index_physical_stats

    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

    October 31, 2011 at 9:37 am

    #1401146

  • RE: Reindex failed primary file group not enough space

    sqlfriends (10/31/2011)

    When you say it's 100-120 % of original objects, you mean use the space in data file or log file.

    Both.

    100% the size of the index + log header overheads...

    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

    October 31, 2011 at 9:22 am

    #1401137

  • RE: 70-448 after december 2011

    Did you ask the test centre why 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

    October 31, 2011 at 9:21 am

    #1401136

  • RE: HELP! Disk Full. Error message: log_reuse_wait_desc

    First things first. Please read through this - Managing Transaction Logs[/url]

    Please, if you do shrink the file (which will be necessary) DO NOT shrink it to 1 (DBCC SHRINKFILE(<filename>,1))

    Doing 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

    October 31, 2011 at 9:03 am

    #1401124

  • RE: possible corruption due to i/o device error

    Denise McMillan (10/31/2011)

    The server adminstrators and our vendor say the drives are ok.

    Those drives are not OK.

    Msg 8966, Level 16, State 2, Line 1

    Unable to read and latch...

    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

    October 31, 2011 at 8:52 am

    #1401118

  • RE: Time Elapsed Testing

    bdotjones (10/31/2011)

    @GilaMonster - The users are going to enter the offset and then its stored in a table. At the beginning of each process we always get the current date,so...

    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

    October 31, 2011 at 8:50 am

    #1401115

Viewing 15 posts - 22,606 through 22,620 (of 49,552 total)