June 2, 2004 at 3:47 pm
Is there any guidelines available for what data types to use and when?
June 3, 2004 at 7:04 am
Not that I have seen. I however believe you should use the smallest datatype that meets your needs and uses the least amount of size when stored. Also consider the data you are storing and how to best constrain it. Some folks will use a char(5) field for zip codes becuase it keeps the leading 0's, but I believe using a int does the zob nicely and add a constriant of between 0 and 99999 which means only numeric values will get in and it uses 4 bytes instead, then you just build the output either thru a view or in the application to add the leading 0's as needed.
June 4, 2004 at 10:19 pm
There's a free e-book available at this URL...
It discusses data types and several other database architecture topics in the context of SQL Server.
Creator of SQLFacts, a free suite of tools for SQL Server database professionals.
June 5, 2004 at 12:01 pm
Thanks a ton Wingenious. This is exactly what I was looking for. Would you also recommend a good book/on-line resource along this line for more in-depth and intermediate/advanced studies.
I will be creating a brand new application so things such as standarda, tips and tricks, strategies, etc. will play a very important part.
Your on-line resource was superb in what I am about to do. Thanks again.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply