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.
Software engineering and business solutions blog featuring SaaS reviews, automation tools, and business insurance guides. Buyer-intent content designed to drive high-quality traffic and conversions.
Subscribe to:
Post Comments (Atom)
Architecture Decision Records: A Comprehensive Guide for Business Leaders
Architecture Decision Records: A Comprehensive Guide for Business Leaders Introduction to Architecture Decision Records What Are Arc...
-
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...
-
Getting the following error (Figure 1): Server Error in '/' Application. ID4014: A SecurityTokenHandler is not registered to ...
-
How to clear SharePoint People Picker suggestion cache If you have been SharePoint Site owner long enough, you would have definitely ...
No comments:
Post a Comment