SQL Server Performance

Row size and Physical table

Discussion in 'Getting Started' started by Asif Ali, May 16, 2007.

  1. Asif Ali New Member

    Do you receive any message that row size is ended and no more records entered?
    When you update any row in enterprise manager in physical table, is there any option to roll back as auto commit is on in SQL server or you physically select the row and update information?

  2. satya Moderator

    By default AUTOGROW will be enabled on the data &log files of your database, unless there is no space on the disk where this data file is located you.

    It is not a best practice to update a table using Enterprise Manager, you must control such update using TSQL queries with BEGIN..END transaction in order to rollback or commit in case of such checkups.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. FrankKalis Moderator

    If that is related to the UPDATE of rows in a table that exceed the max row size of 8060 bytes per row, you might need to reconsider your table design.

    --
    Frank Kalis
    Moderator
    Microsoft SQL Server MVP
    Webmaster:http://www.insidesql.de

Share This Page