In SQL Server 2012, how large is the penalty to update a dynamic type row versus a static one?

Question

It looks like a good practice to use static data types (such as CHAR, NCHAR, BINARY) where update performance is a major concern.

Though I couldn't find any references about how major this penalty is.

Is anybody aware of how big is the loss in throughput if using dynamic data types instead (VARCHAR, NVARCHAR, VARBINARY)?

Check this http://stackoverflow.com/questions/59667/why-would-i-ever-pick-char-over-varchar-in-sql — Pரதீப், Nov 01 '14 at 16:14

score 2 · Answer 1 · answered Nov 01 '14 at 16:19

2

There is no loss. There is no penalty. Use the type appropriate for the application.

answered Nov 01 '14 at 16:19

Remus Rusanu

1 Answers1