Use varchar(max) instead of text in SQL Server

databases As you may know on SQL Server a varchar column can hold up to 8000 characters (each row can hold up to 8K, so it depends on the size of other columns), when you need to store more it is common to use the text or ntext datatypes.


This entry was:

Use Char instead of Varchar to Store UUID's

databases I know a lot of developers like using UUID's for primary keys instead of integers. But one thing I see alot is the use of the varchar datatype to store these strings.


This entry was:

foundeo


did you hack my cf?