Forum Replies Created

Viewing 15 posts - 10,816 through 10,830 (of 49,552 total)

  • RE: fn_virtualfilestats

    Please note: 6 year old thread

    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

    November 27, 2013 at 3:36 am

    #1669389

  • RE: transaction log eats up all the space and growing until sql is stopped

    If it's leaving a transaction open, I suspect the procedure's failing somewhere or has something else wrong.

    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

    November 27, 2013 at 12:02 am

    #1669342

  • RE: incorrect syntax in datetime

    Put the date in single quotes

    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

    November 26, 2013 at 11:42 pm

    #1669337

  • RE: SQL Server Database Administrator next Position or Role

    None of those are promotions from DBA, they're just alternate career paths. To move DBA to one of those would be a side-ways step, not upward.

    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

    November 26, 2013 at 10:12 pm

    #1669325

  • RE: Changing from SIMPLE to FULL to Shrink a Transaction Log?

    JayK (11/26/2013)

    Can anyone explain to me what happened in the TL when I changed the mode from Simple to Full to allow me to shrink it down?

    I'm going to go...

    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

    November 26, 2013 at 10:11 pm

    #1669324

  • RE: transaction log eats up all the space and growing until sql is stopped

    mJai (11/26/2013)

    Thanks, That returned me the following results. From the start time this seems like this process's been running for over 3 days.

    Oldest active transaction:

    SPID (server...

    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

    November 26, 2013 at 9:58 pm

    #1669322

  • RE: Free Disk Space by Clearing Columns ?

    You'll definitely need to rebuild the clustered index to release the free space into the data file for reuse by other tables, may need to run DBCC CleanTable as well

    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

    November 26, 2013 at 11:19 am

    #1669223

  • RE: auto increment problem

    DBCC CheckIdent

    Look in Books Online for the exact syntax and explanation of how it works

    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

    November 26, 2013 at 11:18 am

    #1669222

  • RE: Average Wait time high

    It says locks, so one would assume it has something to do with locks.

    As I said above, the 'average wait time for an instance' is useless. You need to investigate,...

    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

    November 26, 2013 at 8:15 am

    #1669175

  • RE: Average Wait time high

    Depends on what the waits are for. Average wait time by itself is useless, to even begin to start you need to know what waits and what the tool considers...

    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

    November 26, 2013 at 7:58 am

    #1669163

  • RE: What 3rd Party Recovery Tool to Use When DBCC Fails ? Real World Experience

    About fixing metadata, I'm not discussing about the complexity of parsing the files and checking each page's content and I really don't want to go this way. When I said...

    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

    November 26, 2013 at 7:55 am

    #1669162

  • RE: MINIMUM & MAXIMUM Memory in SQL 2012

    7% reserved is low for a server this size. The OS needs memory to map and manage memory. I'd go with Jonathan's recommendations (in book and blog post referenced above)...

    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

    November 26, 2013 at 7:11 am

    #1669138

  • RE: DB Offline

    Zksod (11/26/2013)

    I figure this is sorted... but just check that auto close is not set to ON.

    Autoclose doesn't set the database to the OFFLINE state. A database closed by Auto_Close...

    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

    November 26, 2013 at 6:48 am

    #1669128

  • RE: MINIMUM & MAXIMUM Memory in SQL 2012

    I generally recommend leaving min server memory at 0 unless there's a good reason otherwise. Good reasons may include over-committed virtual machines and multi-instance clusters where it is possible for...

    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

    November 26, 2013 at 6:45 am

    #1669125

  • RE: What 3rd Party Recovery Tool to Use When DBCC Fails ? Real World Experience

    Most of them don't do what they promise. I personally wouldn't use any.

    As for what you use when repair doesn't work - restore. Restore from backup. Emergency mode repair 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

    November 26, 2013 at 6:42 am

    #1669124

Viewing 15 posts - 10,816 through 10,830 (of 49,552 total)