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

Answers were Sorted based on User's Feedback



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

Answer / naresh

8kb and if data(datatypes-varchar,varbinary) exceeds the
8kb row then proceeds to next page pointing with Pointers

Is This Answer Correct ?    12 Yes 0 No

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

Answer / 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

More SQL Server Interview Questions

How do I get to sql server configuration manager?

0 Answers  


What is the difference between mysql and sql server?

0 Answers  


How can sql server instances be hidden? : sql server security

0 Answers  


Which databases are part of SQL server default installation? Explain the usage of each?

2 Answers   Accenture,


Explain alternate key, candidate key and composite key in sql server?

0 Answers  






Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  


What are different types of replication in sql server?

0 Answers  


how we can store the value like that 001,003,023 etc in sql server 2005

7 Answers  


What different steps will a sql server developer take to secure sql server?

0 Answers  


What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  


check, not null,unique

2 Answers   IBM,


Do you know what are acid properties of transaction?

0 Answers  


Categories