http://www.sqlservercentral.com/Articles tagged Data Types posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Our initial reason for looking at the money data type can be found within the Precision Considerations for Analysis Services Users white paper. In this white paper, we provide extensive examples of the types of precision issues when your SQL relational data source and your Microsoft® SQL Server® Analysis Services cube have different non-matching data types (e.g., if you query one way you get the value 304253.3251, but run the query in another way and you get the value 304253.325100001).http://www.sqlservercentral.com/redirect/articles/64488/2008/10/02http://www.sqlservercentral.com/redirect/articles/64488/If you use the new data types in SQL Server 2008, and your front-end application uses .NET 2, you may hit difficulties. András explains why and how...http://www.sqlservercentral.com/redirect/articles/63522/2008/07/10http://www.sqlservercentral.com/redirect/articles/63522/In SQL Server 2005 there is the concept of alias data types, which are similar to user-defined data types in SQL Server 2000. Yakov Shlafman brings us the first part of a series looking at these structures in SQL Server 2000. http://www.sqlservercentral.com/articles/Data+Types/3038/2008/05/30http://www.sqlservercentral.com/articles/Data+Types/3038/That’s correct. SQL Server 2005 SP2 supports data compression using Vardecimal data type.http://www.sqlservercentral.com/redirect/articles/62570/2008/03/18http://www.sqlservercentral.com/redirect/articles/62570/This is the third articlefrom Dinesh Asanka in the series on the new Data Types in SQL Server 2008. In this article the spatial data types are explored.http://www.sqlservercentral.com/redirect/articles/62146/2008/02/22http://www.sqlservercentral.com/redirect/articles/62146/In this article, we are going to explore the new HierarchyID data type. We are going to show how to implement hierarchies in SQL Server 2005 and than how same thing in can be achived in SQL Server 2008 using the HierarchyID data type.http://www.sqlservercentral.com/redirect/articles/62145/2008/02/20http://www.sqlservercentral.com/redirect/articles/62145/To optimize Transact SQL (T-SQL) data types in SQL Server, learn how each type affects performance -- I/O, RAM and CPU in SQL Server.http://www.sqlservercentral.com/redirect/articles/61734/2007/12/26http://www.sqlservercentral.com/redirect/articles/61734/SQL Server 2008 introduces four new DATETIME datatypes as well as new DATETIME functions.http://www.sqlservercentral.com/redirect/articles/61638/2007/12/11http://www.sqlservercentral.com/redirect/articles/61638/SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database. http://www.sqlservercentral.com/articles/Performance+Tuning/2753/2007/12/10http://www.sqlservercentral.com/articles/Performance+Tuning/2753/Continuing on with his series on ADTs, Yakov Shlafman takes a look at working with schema changes when your ADT is on a column used as a primary or foreign key. http://www.sqlservercentral.com/articles/Data+Types/3247/2007/09/27http://www.sqlservercentral.com/articles/Data+Types/3247/In SQL Server 2005 there is the concept of alias data types, which are similar to user-defined data types in SQL Server 2000. Yakov Shlafman brings us the first part of a series looking at these structures in SQL Server 2000. http://www.sqlservercentral.com/articles/Data+Types/3038/2008/05/30http://www.sqlservercentral.com/articles/Data+Types/3038/SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database. http://www.sqlservercentral.com/articles/Performance+Tuning/2753/2007/12/10http://www.sqlservercentral.com/articles/Performance+Tuning/2753/Last week we discussed character datatypes and their performance effects on your database. This week,we will dive into numeric datatypes. We will discuss how SQL Server numeric datatypes are stored and the pros and cons of each. http://www.sqlservercentral.com/articles/Data+Types/numericdatatype/174/2004/10/29http://www.sqlservercentral.com/articles/Data+Types/numericdatatype/174/The Unique Identifier datatype in SQL Server has tremendous potential to solve many of the issues one finds with Identity fields, other primary keys, etc. However it also has some drawbacks and limitations. Author Sharad Nandwani looks at some of the pros and cons of this datatype. http://www.sqlservercentral.com/articles/Data+Types/uniqueidentifierusageandlimitations/1406/2004/06/24http://www.sqlservercentral.com/articles/Data+Types/uniqueidentifierusageandlimitations/1406/Joseph has written a couple articles for us and forwarded this link to an article he wrote recently on text type columns. You can see more of his work at http://www.sqlservercentral.com/columnists/jgama/. http://www.sqlservercentral.com/redirect/articles/1197/2003/11/20http://www.sqlservercentral.com/redirect/articles/1197/This article discusses an often-overlooked feature of SQL Server called user-defined data types. http://www.sqlservercentral.com/articles/Administering/userdefineddatatypes/873/2002/12/17http://www.sqlservercentral.com/articles/Administering/userdefineddatatypes/873/Identity columns are last years news. Have you experimented with uniqueindentifiers - better known to programmers as GUID's? Guaranteed to be unique in the world, they offer a powerful alternative to identity columns. http://www.sqlservercentral.com/articles/Basics/usinguniqueindentifierinsteadofidentity/439/2001/09/17http://www.sqlservercentral.com/articles/Basics/usinguniqueindentifierinsteadofidentity/439/Last week we discussed character datatypes and their performance effects on your database. This week,we will dive into numeric datatypes. We will discuss how SQL Server numeric datatypes are stored and the pros and cons of each. http://www.sqlservercentral.com/articles/Data+Types/numericdatatype/174/2004/10/29http://www.sqlservercentral.com/articles/Data+Types/numericdatatype/174/In the latest release of SQL Server, Microsoft has added a number of new data types to expand the functionality of SQL Server. http://www.sqlservercentral.com/articles/Data+Types/sql2knewdatatypes/162/2001/05/14http://www.sqlservercentral.com/articles/Data+Types/sql2knewdatatypes/162/The type of datatypes that you use in your schema could impact the performance and the accuracy of your database. http://www.sqlservercentral.com/articles/Miscellaneous/datatype/173/2001/05/07http://www.sqlservercentral.com/articles/Miscellaneous/datatype/173/