Forum Replies Created

Viewing 15 posts - 19,861 through 19,875 (of 49,552 total)

  • RE: Transaction log growing very quickly Need to truncate it

    Please read through this - Managing Transaction Logs[/url]

    p.s. Large transaction log does not cause high memory usage.

    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 8, 2012 at 4:13 am

    #1456431

  • RE: SQL Architecture Consolidation

    Be very careful mixing mirroring with auto failover with clustering. The mirroring timeout is, by default, low enough that should the cluster fail over, the mirroring will likely declare 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

    March 8, 2012 at 4:12 am

    #1456430

  • RE: Failing to restore a compressed backup to another server

    That message usually indicates that the backup is corrupt. Try restoring it on the server that you took the backup on, try restore verifyonly.

    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 8, 2012 at 4:06 am

    #1456427

  • RE: Does a normal transaction log backup initiate a checkpoint?

    p.s. There are some circumstances where it will, but it's not something that happens always like with a database backup.

    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 7, 2012 at 11:06 am

    #1456146

  • RE: Does a normal transaction log backup initiate a checkpoint?

    No it will not.

    No document references, was something that I tested some time back.

    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 7, 2012 at 10:20 am

    #1456131

  • RE: Are the posted questions getting worse?

    This works on Firefox, haven't tried anything else

    http://www.studiosevent.com/newscenter/?id=mssqlamer00feae

    Go to about 55 minutes and you can watch the keynote from the start

    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 7, 2012 at 10:02 am

    #1456117

  • RE: SQL Server memory performance

    Buffer cache hit ratio is a counter that should be ignored mostly.

    http://www.simple-talk.com/sql/database-administration/great-sql-server-debates-buffer-cache-hit-ratio/

    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 7, 2012 at 9:49 am

    #1456109

  • RE: What causes parameter sniffing to start?

    I'm not suggesting that the SET options are causing the problem, just make sure when you test from SSMS you have them set exactly the same way, or you'll get...

    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 7, 2012 at 9:37 am

    #1456100

  • RE: DMV Queries Failing

    That query won't work in anything below compat mode 90. In compat mode 80 and below, only constants, variables or parameters are allowed to be passed to a function, 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

    March 7, 2012 at 9:34 am

    #1456096

  • RE: Are the posted questions getting worse?

    HowardW (3/7/2012)

    Is the SQL 2012 launch event site down for everyone else?

    Yes. The commentary on twitter is not pretty...

    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 7, 2012 at 9:31 am

    #1456094

  • RE: SQL 2012 Launch Event.. not off to a good start..

    And the comments on twitter are not gentle...

    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 7, 2012 at 9:24 am

    #1456088

  • RE: UNIQUE NOT NULL vs PRIMARY KEY

    MyDoggieJessie (3/7/2012)

    Eugene Elutin (3/6/2012)

    Much better now!

    So, what else we can add:

    1. they differ in purpose:

    We are using PK for referential integrity (when paired with FK)

    While UNIQUE NOT NUL...

    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 7, 2012 at 8:39 am

    #1456059

  • RE: DMV Queries Failing

    Compatibility mode of the database you're running this in?

    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 7, 2012 at 8:01 am

    #1456031

  • RE: Execution Plan Creation Time > Query Execution Time

    Post the query? That's not a normal situation.

    Nested views? Nested functions?

    Memory pressure on the server? Contention on the plan cache?

    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 7, 2012 at 7:57 am

    #1456027

  • RE: I deleted about 60 gigs from 4 history tables where does the space that I have cleared go?

    It'll become free space within the data file. You may need to rebuild the clustered index of that table to fully free up the space. Yes, it will make your...

    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 7, 2012 at 7:26 am

    #1455988

Viewing 15 posts - 19,861 through 19,875 (of 49,552 total)