Forum Replies Created

Viewing 15 posts - 19,591 through 19,605 (of 49,552 total)

  • RE: not getting rid of physical reads

    eforta.it (3/25/2012)

    Sorry, Gail - I am talking about where in a high select environment, your buffer cache (the database blocks which are from other SELECTs) will contain aged cache blocks...

    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

    March 25, 2012 at 4:45 pm

    #1464054

  • RE: Detect data changes in a "read-only" database?

    Log readers are around $1000 per license. The transaction log is not intended as an audit log.

    If you can't make any server or database changes then you're pretty much out...

    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

    March 25, 2012 at 3:49 pm

    #1464050

  • RE: not getting rid of physical reads

    eforta.it (3/25/2012)

    It's important to realise that if you have a high changing OLTP database, it's likely you'll have high physical reads as the cache will contain old physical block info.

    Huh,...

    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

    March 25, 2012 at 3:35 pm

    #1464048

  • RE: INFORMATION_SCHEMA to determine the schema of an object

    Yes, it is true. In fact, that's a direct copy from Books Online:

    TABLE_SCHEMA

    nvarchar(128)

    Name of schema that contains the table.

    Important:

    Do not use INFORMATION_SCHEMA views to determine...

    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

    March 25, 2012 at 12:29 pm

    #1464021

  • RE: 70-461 Querying SQL Server 2012 question

    Extract 1: Building up dynamic SQL statements using the system metadata tables.

    Extract 2: Given a SQL statement and a set of tables, constraints, etc, determine (through logic) whether 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

    March 25, 2012 at 10:01 am

    #1464004

  • RE: Shipping 2ndary DB now suspect

    Restore. You can't attach a database and leave it restoring, which is required for log shipping to work.

    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

    March 25, 2012 at 7:06 am

    #1463997

  • RE: Reclaim Transaction Log Space

    Please post new questions in a new thread. Thank you.

    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

    March 25, 2012 at 4:29 am

    #1463992

  • RE: How much memory should be allocated to SQL Server 2008 R2 64 Bit Enterprise

    Lian (3/24/2012)

    Now if you were to set it to use 9 gig out of 10 gigs the server administrators are seriously concerned and raise the alarms and eventually...

    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

    March 25, 2012 at 4:22 am

    #1463991

  • RE: Shipping 2ndary DB now suspect

    Now, about the corruption...

    While I would still like to see the error messages to be sure, with a suspect log shipping secondary you're probably best off dropping the secondary DB...

    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

    March 25, 2012 at 4:19 am

    #1463990

  • RE: Shipping 2ndary DB now suspect

    Jake Shelton (3/24/2012)

    But you DO see the contradiction, I hope? When I attempted to stop the restore job, EM reported that it wasn't running. The CheckDB result claimed...

    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

    March 25, 2012 at 4:09 am

    #1463989

  • RE: Moving to/from SQL Server versions

    IgorMi (3/24/2012)

    My right question is if I'd have any other problems returning from SQL Server 2012 to 2005 by using Attach/Detach?

    Yes. It won't work at all.

    SQL databases can never 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

    March 24, 2012 at 2:45 pm

    #1463944

  • RE: Shipping 2ndary DB now suspect

    Jake Shelton (3/24/2012)

    Hi all,

    We have a DB whose 15-min interval log shipping recovery job has been failing for 2 weeks (wasn't me, I'm the whistle-blower, not the negligent!) and...

    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

    March 24, 2012 at 10:16 am

    #1463922

  • RE: Reduce the store Procedure execution time

    And the current execution plan please, The actual plan

    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

    March 23, 2012 at 4:46 pm

    #1463860

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (3/23/2012)

    Anyone else going to see The Hunger Games (or seen it)?

    My 13 yr old is rallying the troops to go see it tonight.

    Doesn't show here...

    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

    March 23, 2012 at 4:18 pm

    #1463853

  • RE: Issues with TokenAndPermUserStore in SQL 2008 SP3 Enterprise Edition

    There's some bits written about that in chapter 3 of this http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

    March 23, 2012 at 2:58 pm

    #1463820

Viewing 15 posts - 19,591 through 19,605 (of 49,552 total)