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

what exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,


What is the default isolation level of the sql server database?

1 Answers   Ness Technologies,


Can we use where and having clause together?

0 Answers  


What is a dbms wizard?

0 Answers  


Name few of the dcl commands in sql?

0 Answers  






How to list all triggers in the database with sys.triggers in ms sql server?

0 Answers  


How to write a query with a full outer join in ms sql server?

0 Answers  


What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,


Explain the ways to controlling cursor behavior?

0 Answers  


How does using a separate hard drive for several database objects improves performance right away?

0 Answers  


How to download and install the scaled-down database adventureworkslt?

0 Answers  


Categories