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 to find the service pack installed? : sql server database administration

0 Answers  


Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,


Explain go command in sql server?

0 Answers  


What are constraints in microsoft sql server?

0 Answers  


how to find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,






What are system databases into sql server (2005/2008)?

0 Answers  


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

0 Answers  


What are different backups available in sql server?

0 Answers  


What are constraints? Explain different types of constraints?

26 Answers   Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,


How to write a query with an inner join in ms sql server?

0 Answers  


what is joins please explain breffly ??

1 Answers   Adaequare, TCS,


What are subqueries in sql server?

0 Answers  


Categories