Maximum SQL Query lenght

Hi all!

Does anybody know what is subject?

Thanks!

This is batch size from ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/13e95046-0e76-4604-b561-d1a74dd824d7.htm

Maximum Record (Row) lenght?

I could not find how to visualize the record lenght of a
table in SQL Server Ent. Manager. Is there a way?
Is it true that the record lenght for a single table
cannot exceed 8086 bytes in SQL Sever?
THANK YOU!
DDursun (anonymous@.discussions.microsoft.com) writes:
> I could not find how to visualize the record lenght of a
> table in SQL Server Ent. Manager. Is there a way?
I have never seen any information on this, but I have not looked for it
either, and I use EM sparingly.
> Is it true that the record lenght for a single table
> cannot exceed 8086 bytes in SQL Sever?
Yes. The exception is if you use text, ntext or image columns. These
datatypes can accomdate up to 2GB for a single value. But they are
not stored within the row, but in a spoce of their own.
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp|||Hi Dursun,
For in-depth information follow the links
http://www.sql-server-
performance.com/ac_65_data_structure.asp ( for SQL Server
6.5)
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4885 (
for SQL Server 7.0).
Best Regards
Chip
>--Original Message--
>Dursun (anonymous@.discussions.microsoft.com) writes:
>> I could not find how to visualize the record lenght of
a
>> table in SQL Server Ent. Manager. Is there a way?
>I have never seen any information on this, but I have not
looked for it
>either, and I use EM sparingly.
>> Is it true that the record lenght for a single table
>> cannot exceed 8086 bytes in SQL Sever?
>Yes. The exception is if you use text, ntext or image
columns. These
>datatypes can accomdate up to 2GB for a single value. But
they are
>not stored within the row, but in a spoce of their own.
>
>--
>Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
>Books Online for SQL Server SP3 at
>http://www.microsoft.com/sql/techinfo/productdoc/2000/book
s.asp
>.
>