what is the maximum size of a row in sql server 2000 and 2005

Answer Posted / mallikarjun

Hi i am mallikarjun, i am new to this site.
As per the Naresh said 8kb, i think that is for one page.
In one extent contains 8pages, each page size is 8kb.
overall one extent contail 64kb.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of backups avaialabe in sql server 2005?

630


What are the commands used in DCL?

572


What is the latest version of microsoft sql server?

490


What is the difference between update lock and exclusive lock?

504


what kind of lan types do you know? : Sql server database administration

527






Is natural join and equi join same?

542


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

555


How to start and end transact-sql statements?

592


what are different types of backups available in sql server? : Sql server database administration

505


what is a self join? Explain it with an example? : Sql server database administration

508


What are commonly used mssql functions in php?

568


What are the pre-defined functions in the sql server?

532


What is a unique key constraint?

539


Explain the architecture of ms sql reporting service?

538


What do you mean by acid?

588