Unanswered: Ntext & text storage - how do these work?
Can some one please explain how the storage of a huge text or ntext object ( say a string of characters 100 KB in size ) is carried out please?
With a data page maximum size of 8000 bytes, how does SQL handle the storage of such an string - it would obviously obverlap multiple rows etc.
Does the application writing it to the database have to split the object over multiple rows and manually keep track of which bit is in which row so it can be re-created later in correct sequence by adding the bits back together, or is it done some how differently?
In SQL 7.0 and later, it happens pretty much like writing a text file. The client spews a bunch of data toward the server, which stores it to disk... At some later point in time, a client requests the data which the server sends back. No moving pieces of significance.