Select from following answers:- Avoid NCHAR/NVARCHAR and use CHAR/VARCHAR
- Avoid using VARCHAR(MAX)
- Use schema naming convention
- Don't use recursive Stored procedure
- All Above
a)Try to avoid NCHAR/NVARCHAR and use CHAR/VARCHAR as the former will unnecessary cosumes 2 bytes more as compared to the later since the former is meant for unicode
characters storage.
b)Avoid using VARCHAR(MAX) because we cannot apply indexing on that.
c)Use schema naming convention as it helps the SQL Server for finding that object in a specific schema.
d)Never write a recursive Stored procedure.It is limited to 32 recursions. Instead use a Recursive Common Table Expression along with OPTION clause.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator