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 time data type in sal server 2008?
What are the five major components of a dbms?
I have to display ten columns values from diffrent ten tables. how many joins are require?
10 Answers CarrizalSoft Technologies, HCL,
What are the purposes and advantages stored procedure?
How to find index size for each index on table?
List all the types of user-defined functions?
i want table name basis on column name.
State a few properties of relational databases?
How do you optimize Sql queries ?
What is the STUFF function and how does it differ from the REPLACE function?
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.
What is a coalesce function?
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)