Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Content with tag
Data Types
Refine your search with one of the following additional tags (with number of items):
Database Design
(10)
Strategies
(2)
Data Compression
(1)
Naming Standards
(1)
T-SQL
(6)
Administering
(1)
dd
(1)
SQL Server 2005
(1)
SQL Server 2008
(4)
Basics
(1)
Miscellaneous
(1)
SQL Server 7, 2000
(1)
Performance Tuning
(2)
Items 1 to 20 of 21
Next 20 >>
SQL Server 2008: new data types and .Net 2 with and without SP1
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...
Read more...
By
Additional Articles
2008/07/10
|
Source:
SimpleTalk
|
Category:
SQL Server 2008
Rating:
(not yet rated)
Rate this
|
Briefcase
|
18 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
|
4,698 reads
CASTing
Read more...
By
Carlo Romagnano
2008/05/29
|
Category:
Data Types
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,343 reads
CASTing
Read more...
By
Carlo Romagnano
2008/05/27
|
Category:
T-SQL
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,623 reads
Bit data
Read more...
By
Dr. Diana Dee
2008/05/07
|
Category:
T-SQL
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,388 reads
Implicit Conversions
Read more...
By
Site Owners
2008/05/05
|
Category:
T-SQL
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
4,024 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
|
2,538 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
|
2,854 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
|
2,970 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
|
2,576 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,304 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
|
15,312 reads
Default Character Cast
Read more...
By 2007/12/07
|
Category:
Data Types
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,079 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
|
1,902 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
|
4,698 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
|
15,312 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 posted: 2001/05/17)
|
Source:
SQLServerCentral.com
|
Category:
Data Types
Rating:
|
Discuss
|
Briefcase
|
12,643 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
|
12,190 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,289 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:
Administering
Rating:
|
Discuss
|
Briefcase
|
6,644 reads
Items 1 to 20 of 21
Next 20 >>
Most popular
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
|
2,576 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,304 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
|
2,970 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use