Forum Replies Created

Viewing 15 posts - 23,236 through 23,250 (of 49,552 total)

  • RE: Best option to perform an update without transaction log growth

    Evil Kraig F (9/27/2011)

    homebrew01 (9/27/2011)

    Evil Kraig F (9/26/2011)

    I would approach this a little differently:

    Is there an advantage ? Gail's seems easier to read, and I think hers could 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

    September 27, 2011 at 12:58 pm

    #1387428

  • RE: REBUILD for heaps

    opc.three (9/27/2011)

    In a write-heavy system with lots of updates to variable-length columns (inner-table page splits) and queries producing table scans heap fragmentation can play a bigger role in performance problems...

    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

    September 27, 2011 at 12:38 pm

    #1387412

  • RE: REBUILD for heaps

    opc.three (9/27/2011)

    GilaMonster (9/27/2011)

    Both.

    From my experience with this client, and admittedly it is my first major dealing with heaps, I see that a high percentage affects performance adversely.

    It probably will,...

    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

    September 27, 2011 at 11:41 am

    #1387380

  • RE: Are the posted questions getting worse?

    Enough? Please????

    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

    September 27, 2011 at 11:04 am

    #1387357

  • RE: REBUILD for heaps

    Both.

    I'm not saying one is the apple, I'm just saying they're not the same thing and so can't be directly compared.

    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

    September 27, 2011 at 11:00 am

    #1387355

  • RE: Can I backup tran log on a principal db (ie. principal in a mirror)

    Derrick Smith (9/27/2011)

    Gail's blog has more info on transaction logs and basic maintenance stuff than you'll likely ever need, so check it out once you get that log backed up...

    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

    September 27, 2011 at 11:00 am

    #1387353

  • RE: REBUILD for heaps

    opc.three (9/27/2011)

    mister.magoo (9/27/2011)

    opc.three (9/27/2011)

    Did you use an INT for your identity column? Try it with BIGINT. I have a theory that since a RID is 8 bytes that using...

    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

    September 27, 2011 at 10:52 am

    #1387341

  • RE: Can I backup tran log on a principal db (ie. principal in a mirror)

    You have to take log backups. Mirroring means full recovery. Full recovery means that the log is only truncated (space marked reusable) when a log backup occurs. So no 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

    September 27, 2011 at 10:44 am

    #1387335

  • RE: Are the posted questions getting worse?

    Enough? Please?

    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

    September 27, 2011 at 10:37 am

    #1387325

  • RE: Device activation error. The physical file name

    That's not what we meant by security. Security would have been the SQL account not having permission on the files. This was just a mis-behaving (or incorrectly configured) application.

    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

    September 27, 2011 at 10:36 am

    #1387323

  • RE: Doubt on LSN

    Yuri55 (9/27/2011)

    Gail,

    Can you please clarify this a bit unusual case (I mean Full-TrLog-Diff backups)?

    This isn't at all an unusual case...

    Let's assume there were no transactions during backups (only some inserts...

    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

    September 27, 2011 at 10:20 am

    #1387312

  • RE: Cache - Hit & Miss

    http://sqlinthewild.co.za/index.php/2010/07/27/hit-and-miss/

    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

    September 27, 2011 at 9:56 am

    #1387287

  • RE: How to rename SQL ServerName?

    No, the link showed how to rename a SQL Server instance. The question was perfectly clear.

    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

    September 27, 2011 at 9:43 am

    #1387272

  • RE: Log File Size is CRITICAL **

    SKYBVI (9/27/2011)

    You must immediately back up your transaction log file. Maybe, decrease the time interval of T log backups if possible.

    Not necessarily. That'll only help if the cause of 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

    September 27, 2011 at 9:26 am

    #1387249

  • RE: How to rename SQL ServerName?

    http://msdn.microsoft.com/en-us/library/ms143799.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

    September 27, 2011 at 9:25 am

    #1387247

Viewing 15 posts - 23,236 through 23,250 (of 49,552 total)