what is the maximum size of a row in sql server 2000 and 2005
Answer Posted / 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 |
Post New Answer View All Answers
Can we use where and having clause together?
Define magic tables in sql server?
What happens if null values are involved in datetime operations?
Mention the differences between sql server and mysql.
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What is difference between views and tables?
How will you monitor replication latency in transactional replication? : sql server replication
How to throw custom exception in Stored Procedure?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What is the difference between system objects and user objects?
What is relationship? What number of sorts of relationship are there?
What the different components in replication and what is their use?
Name some of the open source software that you can use in alternative to SSR?
What is rank function?
Can you please explain the difference between primary keys and foreign keys?