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
Explain about protocol layer present in SQL server?
What is a transaction and why is it important?
What is the meaning of resultset type_scroll_insensitive?
What are various aggregate functions that are available?
How dts is used to extract, transform and consolidate data?
Can you please differentiate between a primary key and a unique key?
How to add more data to the testing table in ms sql server?
State a few properties of relational databases?
What is apply operator in sql?
What is the difference between mysql and mysqli?
What is change data capture (cdc) feature?
Explain what is analysis service repository?
What is the difference between osql and query analyzer?
how to do partition in sqlserver
How to view the error log for any specific instance? : sql server database administration