Data Types

by Jamal A
The article I read talks about the most important contemplations of selecting correct data types when designing a SQL Server database. It talks about how choosing a correct data type in the database design phase can have a significant impact on the efficiency and performance. According to the article, the SQL Server offers six sets of data types. First and formost commonly used data types that stores numeric information are called “The Exact Numeric Data Types” that includes: int, decimal, and money.  The next data type is called “The Approximate Numeric Data Types”, this data type are not as commonly used as the exact numeric data types. The approximate numeric data type includes: float, and real. Moving on, the next data type that is mentioned in this article is called “Date and Time Data Types”, this data types allow designers to easily work with time zones. After that, the next data type in the category is called “Character String Data Types”, it is used to store text values in Microsoft SQL Server databases, and this includes: char, nchar, varchar, nvachar, and text.  The next data type that is mentioned in this article is called “Binary Data Types”, it allows DBAs to store any type of binary data, this includes: bit, binary, varbinary, varbinary(max), and image. Finally, the last data type that is mentioned in this article is called “The Other Data Types”, it includes: cursor, sql_variant, table xml, and uniqueidentifier.

This article relates to class because it talks about the importance of using data types. I learned it the hard way because when I was working on my database project. I did not set my data type correctly and I ended up doing the project twice. So it is important to set the data type correctly in the database design phase. I learned a lot from this article. I just wish I had found this article earlier.

Chapple, Mike. (n.d.). SQL Server Data Types. About Databases: Microsoft Access, SQL Server, Oracle and More!. Retrieved February 27, 2012, from http://databases.about.com/od/sqlserver/a/m

2 thoughts on “Data Types”

  1. This was a very informative article, especially for our project 2. Like the article states, it is very important to choose a correct data type when designing your SQL database. A lot of people messed up this part when design SQL in the project. The hassle associated with fixing the data types is also very annoying. So in order to save yourself the grief, just make sure that you take everything into consideration when choosing your data type because changing it later on is tough. Great article 🙂

  2. I also wrote an article about the different data types and how it can affect the performance of the database. I also had to go back and do some changes to my project 2 after figuring out that I had selected the wrong data type for some of the attributes.

Comments are closed.