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

Explain the use of containers in ssis and also their types?

532


Do you know the cursor types?

622


How the authentication mode can be changed?

611


How to create a dml trigger using create trigger statements?

564


How to access the inserted record of an event?

576






How to create an inline table-valued function?

540


What is the difference between a function and a trigger?

579


What is the security principal at the server level that represents your session?

563


What is ddl command?

538


Explain the steps to use transact-sql cursor?

530


Explain index in sql server?

600


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

1724


Name and describe few console utilities for ssrs?

249


How to count groups returned with the group by clause in ms sql server?

564


What is an indice?

577