what is the maximum size of a row in sql server 2000 and 2005
Answers were Sorted based on User's Feedback
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 |
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 |
How do I get to sql server configuration manager?
What is the difference between mysql and sql server?
How can sql server instances be hidden? : sql server security
Which databases are part of SQL server default installation? Explain the usage of each?
Explain alternate key, candidate key and composite key in sql server?
Differentiate between ms sql server reporting services vs crystal reports?
What are different types of replication in sql server?
how we can store the value like that 001,003,023 etc in sql server 2005
What different steps will a sql server developer take to secure sql server?
What is the difference between lock, block and deadlock? : sql server database administration
check, not null,unique
Do you know what are acid properties of transaction?