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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Where are stored procedures in sql server?

746


To which devices can a backup be created and where should these devices be located? : sql server management studio

731


what are defaults? : Sql server database administration

699


If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

750


What is trace flag in sql server?

718






How will you decide the active and passive nodes?

794


Define indexes?

795


What is tablix?

136


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1477


Explain what is the use of custom fields in report?

689


If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

721


You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

794


What do you mean by data manipulation language?

764


What different steps will a sql server developer take to secure sql server?

724


what data regions are and what are the different data regions?

115