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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is read committed?

613


How to select true false based on column value in sql server?

508


How many database files are there in sql server 2000?what are they?

583


How to create new tables with "create table" statements in ms sql server?

571


How to get a list of columns in a view using "sys.columns" in ms sql server?

523






Define cross join in sql server joins?

595


How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

541


Are resultset updatable?

533


Explain database normalization?

651


What is the difference between a function and a stored procedure?

570


what's sql server? : Sql server database administration

503


How to convert binary strings into integers in ms sql server?

561


What is the fastest way to permanently delete a 1 million row table named customers?

605


How do you Implement SSIS Packages in your Project?

1516


What does Master database contains?

635