Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / ynpradeep

Answers were Sorted based on User's Feedback



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

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

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

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

Post New Answer

More SQL Server Interview Questions

Write the Syntax for Cursors.

2 Answers   CarrizalSoft Technologies, HP,

Can we update data in a view?

0 Answers  

How sql server executes a statement with nested subqueries?

0 Answers  

What is Schema? and why we use schemas?

4 Answers  

What is b tree index?

0 Answers  

Differentiate between mongodb vs. Sql server?

0 Answers  

What is database black box testing?

0 Answers  

Define the term DML, DDL and DTL?

1 Answers  

What is right outer join in sql server joins?

0 Answers  

What happens if date-only values are provided as date and time literals?

0 Answers  

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

logshipping is Any difference 2000 and 2005?

2 Answers  

For more SQL Server Interview Questions Click Here
Categories