Forum Replies Created

Viewing 15 posts - 20,896 through 20,910 (of 49,552 total)

  • RE: SQL compatibility_level changing to 100 by itself on a production database

    Markus (1/19/2012)

    Some one or some ID that has 'sa' rights is about the only thing that can change it really.

    Or database owner of this database.

    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

    January 19, 2012 at 11:15 am

    #1436088

  • RE: SQL compatibility_level changing to 100 by itself on a production database

    mariobehring (1/19/2012)

    My question is...how do I keep the compatibility_level at 80.....how do I prevent it from changing to 100.....that´s it basically. For this particular database, of course.

    You identify who or...

    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

    January 19, 2012 at 11:15 am

    #1436087

  • RE: Question about log shipping from SQL 2005 to SQL 2008

    bsdtux (1/19/2012)

    Good to know thanks guys for the insightfull information. Looks like I do have some planning to do. Since I am still working on only one database server 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

    January 19, 2012 at 11:12 am

    #1436085

  • RE: ISOLATION level difference between Client connections and Database

    _UB (1/19/2012)

    A database that has ISOLATION set to snapshot (Read Committed Snapshot) will accept client connections and assign them "Snapshot" isolation as the default setting (if client does not change...

    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

    January 19, 2012 at 11:07 am

    #1436079

  • RE: Question about log shipping from SQL 2005 to SQL 2008

    Just note that your log shipping is one way. If you ever have to fail over and make the 2008 server the primary, you won't be able to take log...

    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

    January 19, 2012 at 10:37 am

    #1436052

  • RE: ISOLATION level difference between Client connections and Database

    _UB (1/19/2012)

    1: This is an explicit setting that comes from each client connection and Sql Server only obliges that request and assigns the requested ISOLATION level.

    No....

    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

    January 19, 2012 at 10:35 am

    #1436048

  • RE: ISOLATION level difference between Client connections and Database

    _UB (1/19/2012)

    All,

    I have a database set on Snapshot Isolation Level.

    No, you've got a database where snapshot isolation is allowed, and read_committed snapshot is on by default for any connections 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

    January 19, 2012 at 10:21 am

    #1436032

  • RE: Getting Poor Performance - SQL Server

    Have you checked for blocking?

    Have you checked what wait types those queries have (not the aggregated, the wait types for those queries)?

    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

    January 19, 2012 at 9:31 am

    #1435995

  • RE: SQL Certifications

    SQLKnowItAll (1/19/2012)

    So, can I buy these books used or do I have to register that I bought it? Let's say I was a know-it-all and just wanted to sign...

    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

    January 19, 2012 at 9:20 am

    #1435971

  • RE: Getting Poor Performance - SQL Server

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    And I strongly recommend you have a look at this: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Re memory: If you tell SQL that it can use 24 GB, it will use 24 GB. If that's too...

    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

    January 19, 2012 at 8:58 am

    #1435943

  • RE: SQL Certifications

    There's no single answer to this question. Take the certifications that you feel will have value in your current position or future plans. Pick the learning type that works 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

    January 19, 2012 at 8:56 am

    #1435941

  • RE: Truncate Log File

    No, you don't need to shrink the log file. It's full. It has no free space in it. Therefore you need to grow the file, not shrink it.

    Shrinking a full...

    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

    January 19, 2012 at 8:53 am

    #1435937

  • RE: Database in Recovery, taking over 6 hours to come out of recovery mode

    http://www.sqlskills.com/BLOGS/KIMBERLY/post/8-Steps-to-better-Transaction-Log-throughput.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

    January 19, 2012 at 7:08 am

    #1435815

  • RE: Database in Recovery, taking over 6 hours to come out of recovery mode

    I'm willing to bet you have several hundred or thousand VLFs. It's the one thing that absolutely can cause this. Otherwise, massive transaction that hadn't completed at time or shutdown...

    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

    January 19, 2012 at 6:31 am

    #1435779

  • RE: Seems master db got corrupt.Please help.

    If you have copies of the master files, shut down SQL (it's probably already stopped) and copy the copies of the files over the existing files. You'll lose any logins...

    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

    January 19, 2012 at 6:27 am

    #1435774

Viewing 15 posts - 20,896 through 20,910 (of 49,552 total)