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 |
what exactly sql injuction.how to overcome.....
What is the default isolation level of the sql server database?
Can we use where and having clause together?
What is a dbms wizard?
Name few of the dcl commands in sql?
How to list all triggers in the database with sys.triggers in ms sql server?
How to write a query with a full outer join in ms sql server?
What are the advantages of using views. Why do we need views when we have SPs?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
Explain the ways to controlling cursor behavior?
How does using a separate hard drive for several database objects improves performance right away?
How to download and install the scaled-down database adventureworkslt?