Forum Replies Created

Viewing 15 posts - 21,586 through 21,600 (of 49,552 total)

  • RE: Database Designing issue

    How often are you likely to add new entities? Can I assume this is a travel agent or similar setup?

    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

    December 22, 2011 at 5:42 am

    #1424737

  • RE: Dead locks during multiple insertions

    Maybe. Depends on a whole lot of things, schema, indexes, code, isolation level.

    To write a list of all things that cause deadlocks would take a week or two. In short,...

    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

    December 22, 2011 at 3:53 am

    #1424690

  • RE: Transaction Log file suspicious high

    My gut feel would be index rebuilds. They're usually the culprit for stuff like this

    Basically, you are looking for an unusually large number of fully-logged transactions.

    Even a huge minimally...

    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

    December 22, 2011 at 3:50 am

    #1424687

  • RE: How Reliable is this DBCC DBINFO

    Many people do, I have some 3rd party products that do. For an undocumented command, it's pretty well known.

    It may change in the next version or even next service pack...

    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

    December 22, 2011 at 3:47 am

    #1424685

  • RE: upgrade sql 2008 10.00.1600.22 to SQL Server 2008 R2 10.50.1600.1

    Depends how you're doing the transfer.

    Easiest way, if it's a small number of tables is the Import/Export wizard. That will create the table for you, but you'll still have to...

    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

    December 22, 2011 at 3:39 am

    #1424681

  • RE: differential backup at the time of indexing and database defrag

    You can. It's going to hit the IO subsystem hard, with two heavy IO tasks at the same time. It's also going to make the diff larger than it probably...

    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

    December 22, 2011 at 3:37 am

    #1424679

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (12/21/2011)

    GilaMonster (12/21/2011)

    jcrawf02 (12/21/2011)

    I think it's similar to this explanation of photos taken of plane propellers[/url], we're really seeing layered snapshots of a photon pulse moving through the...

    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

    December 21, 2011 at 1:37 pm

    #1424447

  • RE: Are the posted questions getting worse?

    jcrawf02 (12/21/2011)

    I think it's similar to this explanation of photos taken of plane propellers[/url], we're really seeing layered snapshots of a photon pulse moving through the target, recreated as 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

    December 21, 2011 at 11:21 am

    #1424384

  • RE: Are the posted questions getting worse?

    You're watching the progression of a pulse of light as it moves over an object, at 300 000 000 m/s

    Like watching slo-mo of a bullet through an apple, except this...

    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

    December 21, 2011 at 11:14 am

    #1424379

  • RE: Does a SQL backup write tot he transaction log file?

    wchaster (12/21/2011)

    I did check and there is a maintenance plan that runs index reorganizations that executed during this time frame. This task completes in less than an hour, 35 to...

    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

    December 21, 2011 at 10:47 am

    #1424370

  • RE: Are the posted questions getting worse?

    Slow motion photography anyone?

    http://scienceblogs.com/startswithabang/2011/12/how_to_make_the_slowest_slow-m.php

    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

    December 21, 2011 at 9:55 am

    #1424347

  • RE: Are the posted questions getting worse?

    Jim Murphy (12/21/2011)

    Oh, Jonathan's book that you (Gail) tech edited rocks! I bought 10 print copies as give away's in presentations. Arrived a few days ago. Since 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

    December 21, 2011 at 9:15 am

    #1424321

  • RE: Sharepoint database administration guidence needed

    Divine Flame (12/21/2011)

    Therefore I think I should start looking for some other document :hehe:

    Get the one that Paul rewrote. If anyone knows how to admin SQL properly it's him (see...

    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

    December 21, 2011 at 8:26 am

    #1424279

  • RE: Restore DB backup from Enterprise Edition to Standard Edition

    Providing you're not using the persistent Enterprise-only features (partitioning, compression, TDE), an Enterprise edition DB can even be restored to Express (if small enough). Most of the time you can...

    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

    December 21, 2011 at 7:56 am

    #1424255

  • RE: Frozen Jobs, SPIDS, and Rollback

    Brandie Tarvin (12/21/2011)

    Gail,

    I think I just found something. Read Jag's post here: http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/71d3cd0b-ce4d-4202-8e3b-38b38da90a5b. It sort of makes sense to me, but I'm wondering what else could be affected if I...

    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

    December 21, 2011 at 7:54 am

    #1424251

Viewing 15 posts - 21,586 through 21,600 (of 49,552 total)