What are the main performance differences between varchar and nvarchar SQL Server data types?

by

Disk space is not the issue… but memory and performance will be.
Double the page reads, double index size, strange LIKE and = constant behaviour etc

Do you need to store Chinese etc script? Yes or no…

And from MS BOL “Storage and Performance Effects of Unicode”

Edit:

Recent SO question highlighting how bad nvarchar performance can be…

SQL Server uses high CPU when searching inside nvarchar strings

More Related Contents:

  1. What is the difference between varchar and nvarchar?
  2. nvarchar(max) vs NText
  3. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  4. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  5. Parameter Sniffing (or Spoofing) in SQL Server
  6. Storing a file in a database as opposed to the file system?
  7. How to get Time from DateTime format in SQL?
  8. SQL Server String or binary data would be truncated
  9. Natural (human alpha-numeric) sort in Microsoft SQL 2005
  10. Datatype for storing ip address in SQL Server
  11. How to change identity column values programmatically?
  12. Why is it considered bad practice to use cursors in SQL Server?
  13. CAST and IsNumeric
  14. SQL Server pivot vs. multiple join
  15. SQL Query to find the last day of the month
  16. SQL Server, convert a named instance to default instance?
  17. SQL Server GUID sort algorithm. Why?
  18. WHERE clause on SQL Server “Text” data type
  19. SQL Server error on update command – “A severe error occurred on the current command”
  20. Parse XML in SQL Server
  21. SQL server schema and default schema
  22. SQL Server ON DELETE Trigger
  23. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  24. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  25. FOR XML PATH(”): Escaping “special” characters
  26. How to store directory / hierarchy / tree structure in the database?
  27. INFORMATION_SCHEMA vs sysobjects
  28. Does query plan optimizer works well with joined/filtered table-valued functions?
  29. Get row where datetime column = today
  30. Full text catalog/index search for %book%

Leave a Comment