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 to find the service pack installed? : sql server database administration
Difference between writing SQL query and stored procedure ?
15 Answers Cognizant, Infosys, TCS, Veritas,
Explain go command in sql server?
What are constraints in microsoft sql server?
how to find maximum identity number in a table ?
2 Answers JPMorgan Chase, Thomson Reuters, Wipro,
What are system databases into sql server (2005/2008)?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What are different backups available in sql server?
What are constraints? Explain different types of constraints?
26 Answers Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,
How to write a query with an inner join in ms sql server?
what is joins please explain breffly ??
What are subqueries in sql server?