8kb and if data(datatypes-varchar,varbinary) exceeds the 8kb row then pr

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

Question Posted / naresh

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

Please Help Members By Posting Answers For Below Questions

Explain trigger and trigger types?

945

why would you call update statistics? : Sql server database administration

1060

What are the five major components of a dbms?

919

What is the purpose of linked server configuration in sql server?

1018

What is factless fact table? : sql server analysis services, ssas

1006

What are the differences between lost updates and uncommitted dependencies?

1050

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1033

What is sql server agent and what are the two modes of authentication in sql server?

1034

What is sql service broker?

964

Give the query of getting last two records from the table in SQL SERVER?

925

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

982

What are “unrepeatable reads”?

1214

What is the language structure to add a record to a table?

1008

Explain external key management in sql server 2008

869

What is for xml in sql server?

1041