Forum Replies Created

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

  • RE: Performance Implications of Database Snapshots

    matt stockham (9/23/2008)

    Nice article. I have a few questions:

    1) why do inserts scale so much better than updates and deletes on a workstation? A page is a page,...

    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 24, 2008 at 12:36 am

    #876135

  • RE: Users: Are they active?

    Jeff Moden (9/23/2008)

    GilaMonster (9/23/2008)

    On a fairly active server I used to work with, on SQL 2000 we were writing a 200MB C2 file about every 15 min. After we upgraded...

    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 24, 2008 at 12:35 am

    #876134

  • RE: sql query to find statement currently executing in sp

    Jeff Moden (9/23/2008)

    Heh... I still want to know why the op wants to do this. :hehe:

    Dunno about the OP, but I had a very similar piece of code in one...

    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 24, 2008 at 12:25 am

    #876132

  • RE: Determine fragmentation of HEAP table

    Wilfred van Dijk (9/23/2008)

    Thanks for your input. Thus: forwarding pointers can only occur on heaps, while page splits only occur on indexes?

    Pretty much.

    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 24, 2008 at 12:22 am

    #876130

  • RE: Another Backup scenario

    Ahmad Osama (9/23/2008)

    GilaMonster (9/23/2008)

    To recover in this scenario you need a full backup from before the table was dropped and an unbroken log backup chain from that full backup 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 24, 2008 at 12:21 am

    #876129

  • RE: Determine fragmentation of HEAP table

    Wilfred van Dijk (5/26/2008)

    Hi,

    AFAIK, A heap table can be fragmented because of page splits, which results in forward lookups.

    Is there a way to calculate this fragmentation?

    Heaps don't suffer page...

    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 23, 2008 at 3:34 pm

    #876049

  • RE: Dangers of using MYSQL...What are they?

    The main problem I would see is the learning curve. MySQL can run on windows, but it will still require some time to get familiar with the admin requirements 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

    September 23, 2008 at 2:34 pm

    #876030

  • RE: Update Stats for SQL Server 2005

    fais (9/23/2008)

    I see some columns in sys.dm_db_index_operational_stats like leaf_insert_count,leaf_delete_count,leaf_update_count......................... Have microsoft changed prior functionality into this............Please let us know if you know something (or) anyway to modify the script.............(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

    September 23, 2008 at 2:27 pm

    #876027

  • RE: Backup one particular table

    Not using the native backup tools.

    You can always bcp the table out, or make a copy of it in another DB with select .. into

    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 23, 2008 at 1:34 pm

    #875995

  • RE: cursor and rollback transaction

    Pleasure

    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 23, 2008 at 12:57 pm

    #875974

  • RE: SQL Server Black Book on Indexes & Statistics, Got One?

    YSLGuru (9/23/2008)

    Is there an easy way to ask SSMS to locate any column in any able of a database that is setup with the data type unique identifier?

    Why not ask...

    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 23, 2008 at 12:55 pm

    #875971

  • RE: cursor and rollback transaction

    If you define an explicit transaction, and do the appropriate error handling, you can roll the whole lot back. I suggest using Try..Catch as @@error requires a check after every...

    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 23, 2008 at 12:20 pm

    #875948

  • RE: Another Backup scenario

    To recover in this scenario you need a full backup from before the table was dropped and an unbroken log backup chain from that full backup up until just before...

    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 23, 2008 at 12:16 pm

    #875947

  • RE: Split and move data from one file to multiple files

    sqldba (9/23/2008)

    One other thought,

    Instead of creating two new file groups, Can I add two files to the same primary filegroup point to new disks, then use dbcc shrinkfile(filename, empty)...

    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 23, 2008 at 12:14 pm

    #875946

  • RE: Execution Plan question

    Do you have a reason for wanting the queries to not run paralleled?

    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 23, 2008 at 11:35 am

    #875927

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