Joe's Knowledge Base - A Collection of Various Tips-N-Tricks (Software) that I really get tired of having to find again each time I need them. Now ... where did I (put/find) that ...
Thursday, April 24, 2008
SQL Server 2005 Long Varchar Storage
2k vs. 2k5 difference – 2k5 will allow table content to exceed 8060 chars – it puts in a 24 bit ref. & stores the offending data in a different page. Not a great idea but it does prevent the app from breaking.