Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by pheiner
-
INSERT not always going to bottom
Also check for a clustered index on the table.- pheiner
- Post #4
- Forum: Microsoft SQL Server: Programming
-
char vs. varchar storage size
I agree, "If the field is always a specific length use a char". A varchar adds a byte so that the server can tell how long it is plus the cpu cycles to work it out. When I decide between char and varchar I am considering the storage space used. If you use a char(30) and the...- pheiner
- Post #5
- Forum: Microsoft SQL Server: Programming
