TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Bineesh Viswanath
NA
1k
777.8k
Tips to SQL Server Fast Performance
Oct 11 2013 11:54 PM
Sir, I need your help in the following subject.
has data Type declaration a major role in the performance?
suppose I gave data Type varchar(max) to column 'Gender'. As Gender comes only 4 or 5 characters, is this absurd to give varchar(max)?
Like that could you send me data Type to be used for the following:-
1) primary key,
2) Name,
3) Address,
4) rate(for decimal points also)
5) quantity.
6) discount,
7) tax,
8) phone number(with 14 digits),
9) country,
10) currency,
11) date,
12) age.
Please reply with giving appropriate data Type to these coulmns.
Reply
Answers (
3
)
phone no validation in sql server
Difference between numeric(18,0) and Int