SQL Server and SqlDataReader - Trillion Records - Memory

Question

I have never tried this - so I don’t know if I ran into memory problems.

But can SqlDataReader read a trillion records? Is this all right? I am a little green, which makes the SQL / TDS protocol under covers.

UPDATE Trillion translation means a very large amount. I probably should have said something like 1 billion or 100 million.

Answer 1

Yes, it will be a stream ... but I do not think that you really should do it.

( ), 12 , ..., , .

, , , , , , " " , , , .

Answer 2

.

• SqlDataReader . BLOB-, 2 (XML, VARBINARY (MAX), VARCHAR (MAX), NVARCHAR (MAX)). , CommandBehavior.SequentialAccess ExecuteReader SqlClient, SqlBytes.Stream.

• SqlDataReader. , - , . conneciton , . Loution MARS. , MultipleActiveResultSets=True . , ( --). Christian Kleinerman , , MARS , .

• . , , . ( , ), - ( ), , leissure.

• . . , VLF, .

• . 999- , , 12 "".

Answer 3

. ( SQL , - ), , SqlDataReader .