sql server msde: Maximum row size for SQLExpress -- sql server msde

You're in the

sql server msde

group:

Maximum row size for SQLExpress

John Scott
9/23/2005 1:12:02 PM

sql server msde: I was just wondering if SQLExpress will have the same maximum row size
funcationality as SQL Server 2005. (being able to have a single row go
accross multiple pages and allow the entire row to exceed 8060 bytes)?

Thanks,

Re: Maximum row size for SQLExpress

Mike Epprecht (SQL MVP)
9/23/2005 10:54:56 PM

Hi

8060 applies. If you use the new datatypes NVARCHAR(max) and VARCHAR(max),
those data types get sliced up the SQL Server itself across multiple pages.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]

Re: Maximum row size for SQLExpress

Roger Wolter[MSFT]
10/2/2005 7:26:22 AM

Yes, Express has the extended row size functionality introduced in SQL
Server 2005.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server msde group.

home · blog · groups

Questions? Comments? Contact the dn