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 |
Explain the phases a transaction has to undergo?
What are the triggers in sql?
How to find the latest updated value in a table without sending any parameters to that query
Explain temporary table vs table variable by using cursor alternative?
What is BCP? When does it used in sql server 2012?
0 Answers TryTechnicals Pvt Ltd,
how to trace the traffic hitting a sql server? : Sql server database administration
What is the server name for sql management studio?
Explain subquery and state its properties?
what authentication modes does sql server support? : Sql server database administration
What is store procedure? How do they work? When do you use?
Explain how to integrate the ssrs reports in application?
What is the default value of an integer data type in sql server 2005?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)