Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Data Types Rss

Search for any content tagged data types

<< Newer    Items 21 to 38 of 38   
 

Reverse Engineering Alias Data Types in SQL Server 2000

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.   Read more...
By Yakov Shlafman 2007/06/19 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 5,797 reads

Data Compression in SQL Server 2005 (Believe it !!)

That’s correct. SQL Server 2005 SP2 supports data compression using Vardecimal data type.  Read more...
By Additional Articles 2008/03/18 | Source: SQL Community | Category: sql server 2005
Rating:  Rate this |   Briefcase | 3,806 reads

New Data Types in SQL Server 2008 Part 3

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.  Read more...
By Additional Articles 2008/02/22 | Source: SQL Server Performance | Category: data types
Rating: (not yet rated)  Rate this |   Briefcase | 3,445 reads

New Data Types in SQL Server 2008 Part 2

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.  Read more...
By Additional Articles 2008/02/20 | Source: SQL Server Performance | Category: data types
Rating:  Rate this |   Briefcase | 3,852 reads

Optimize T-SQL data types in SQL Server

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.  Read more...
By Additional Articles 2007/12/26 | Source: SearchSQLServer | Category: data types
Rating:  Rate this |   Briefcase | 3,274 reads

SQL Server 2008 New DATETIME DataTypes

SQL Server 2008 introduces four new DATETIME datatypes as well as new DATETIME functions.  Read more...
By Additional Articles 2007/12/11 | Source: SQL Server Performance | Category: sql server 2008
Rating:  Rate this |   Briefcase | 2,877 reads

TinyInt, SmallInt, Int and BigInt

SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database.   Read more...
By David Poole 2006/12/18 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 19,913 reads

Reverse Engineering ADTs in SQL Server 2000 - Part 3

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.   Read more...
By Yakov Shlafman 2007/09/27 | Source: SQLServerCentral.com | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 2,190 reads

Reverse Engineering Alias Data Types in SQL Server 2000

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.   Read more...
By Yakov Shlafman 2007/06/19 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 5,797 reads

TinyInt, SmallInt, Int and BigInt

SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database.   Read more...
By David Poole 2006/12/18 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 19,913 reads

Numeric Datatype Decisions

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.   Read more...
By Brian Knight 2004/10/29 (first published: 2001/05/17) | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 13,796 reads

Unique Identifier: Usage and Limitations

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.   Read more...
By Sharad Nandwani 2004/06/24 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 13,953 reads

Brief Tutorial on Text, Ntext, and Image

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/.   Read more...
By Additional Articles 2003/11/20 | Source: MSDN Communities | Category: data types
Rating:  Rate this |   Briefcase | 1,620 reads

User-defined Data Type Basics

This article discusses an often-overlooked feature of SQL Server called user-defined data types.   Read more...
By Don Frazier 2002/12/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,054 reads

Using Uniqueindentifier Instead of Identity

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.   Read more...
By Andy Warren 2001/09/17 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 11,407 reads

Numeric Datatype Decisions

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.   Read more...
By Brian Knight 2004/10/29 (first published: 2001/05/17) | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 13,796 reads

New SQL Server 2000 Data Types

In the latest release of SQL Server, Microsoft has added a number of new data types to expand the functionality of SQL Server.   Read more...
By Brian Knight 2001/05/14 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 6,557 reads

Character Datatype Decisions

The type of datatypes that you use in your schema could impact the performance and the accuracy of your database.   Read more...
By Brian Knight 2001/05/07 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,567 reads
<< Newer    Items 21 to 38 of 38