NVARCHAR - to be used because if 100 characters are set aka NVARCHAR(100), but only 10 characters are used the amount of space used is 10.
WHERE if NCHAR 100 Characters aka NCHAR(100) , but only 10 characters are used the amount of space used is 100...
Very wasteful on data storage. "KNOW YOU YOUR DATA", as Larry Leonard would say.
Subscribe to:
Post Comments (Atom)
-
The problem was that the remote connection needed to utilize Named Pipes, but in order to utilize Named Pipes both the machine hosting the i...
-
How to clear SharePoint People Picker suggestion cache If you have been SharePoint Site owner long enough, you would have definitely ...
-
Getting the following error (Figure 1): Server Error in '/' Application. ID4014: A SecurityTokenHandler is not registered to ...
No comments:
Post a Comment