What's the maximum size of a row?

Answers were Sorted based on User's Feedback



What's the maximum size of a row?..

Answer / samrat sen

Actual size is 8196 bytes.But Sql Server allows only 8060
bytes of data per row.

Is This Answer Correct ?    13 Yes 1 No

What's the maximum size of a row?..

Answer / vishalu

Maximum row size is 8060 bytes.

Is This Answer Correct ?    7 Yes 0 No

What's the maximum size of a row?..

Answer / kmbkrishnan

8kb (8060 bytes)

Is This Answer Correct ?    4 Yes 2 No

What's the maximum size of a row?..

Answer / visala

max row size is 8060 bytes.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  


What is an inner join?

0 Answers  


What are different types of database indexes?

0 Answers  


What is the difference between primary key and unique constraints?

0 Answers  


How to handle error or exception in sql?

0 Answers  






Differences between logshipping and mirroring

1 Answers   Microsoft, Syntel,


How to view existing indexes on an given table using sys.indexes?

0 Answers  


How to modify the underlying query of an existing view?

0 Answers  


Why I am getting this error when dropping a database in ms sql server?

0 Answers  


what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  


How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  


What is the difference between having and where clause?

4 Answers  


Categories