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

Question Posted / ynpradeep

2 Answers
5001 Views
I also Faced
E-Mail Answers

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

Define ACID properties in a Database?

0 Answers iNautix,

What is Data model and how to prepare a data model.?

1 Answers TCS,

Explain indexed view?

1 Answers

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers

explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers

Explain how many types of relationship?

0 Answers

How to execute a sql statement using mssql_query()?

0 Answers

How can we write or define DDL statements in Sql server and DML statements?

3 Answers

what are default? Is there a column to which a default cant be bound?

1 Answers

Differentiate between a having clause and a where clause.