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

Content with tags T-SQL, Data Types Rss

   Items 1 to 20 of 20   
 

Comparing Different Data Types

Comparing columns of different data types can be a drain on resources, as well as our sanity. This is a look into a few strategies for dealing with implicit conversions.  Read more...
By Edward Pollack 2014/05/19 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 6,168 reads

Datatypes In Your Mind

By Andy Warren 2014/05/06 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 2,036 reads

Filestream data

By Steve Jones 2013/09/27 | Category: filestream
Rating: (not yet rated) |  Discuss |   Briefcase | 2,055 reads

Data Type

By Yogesh Kumar 2013/05/10 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 2,153 reads

VARCHAR (MAX), NVARCHAR (MAX) and NTEXT Data Types

Despite NTEXT and TEXT being deprecated in SQL Server for some time they are still both used in production systems. In this article, I will briefly demonstrate the difference between a VARCHAR (MAX), NVARCHAR (MAX) and the NTEXT data types, and the impact on performance from using NTEXT/TEXT.  Read more...
By Additional Articles 2013/01/21 | Source: SQL Server Performance | Category: t-sql
Rating:  Rate this |   Briefcase | 5,680 reads

Data Typing Quandry

By Robert Davis 2010/11/17 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 3,143 reads

SQL Server 2008 T-SQL Enhancements Part - IV

In the fourth installment that looks at T-SQL changes for SQL Server 2008, Ashad Ali examines how the Filestream data type works.  Read more...
By Arshad Ali 2010/03/26 (first published: 2009/08/28) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 19,542 reads

Varchar or Char?

By John Arnott 2009/10/16 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 5,037 reads

SQL Server 2008 T-SQL Enhancements Part - IV

In the fourth installment that looks at T-SQL changes for SQL Server 2008, Ashad Ali examines how the Filestream data type works.  Read more...
By Arshad Ali 2010/03/26 (first published: 2009/08/28) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 19,542 reads

char to datetime!

By VM-723206 2009/08/19 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 4,104 reads

decimal

By VM-723206 2009/06/17 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,643 reads

Investigating the new Spatial Types in SQL Server 2008 - Part 2

This is the second article in the series on the new spatial data types in SQL Server 2008  Read more...
By Bennie Haelen 2008/11/20 | Source: SQLServerCentral.com | Category: spatial data
Rating: |  Discuss |   Briefcase | 5,411 reads

Auto generated SQL Server keys - uniqueidentifier or IDENTITY

I'm designing a table and I've decided to create an auto-generated primary key value as opposed to creating my own scheme or using natural keys. I see that SQL Server offers globally unique identifiers (GUIDs) as well as identities to create these values. What are the pros and cons of these approaches?  Read more...
By Additional Articles 2008/10/23 | Source: MSSQLTips.com | Category: t-sql
Rating:  Rate this |   Briefcase | 4,998 reads

CASTing

By Carlo Romagnano 2008/05/29 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 3,902 reads

CASTing

By Carlo Romagnano 2008/05/27 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 5,121 reads

Bit data

By Diana Dee 2008/05/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,874 reads

Implicit Conversions

By Site Owners 2008/05/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 5,318 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

Default Character Cast

By 2007/12/07 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 3,988 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
   Items 1 to 20 of 20   
 
Tags
database design (2)    
filestream (2)    
performance tuning (2)    
spatial data (2)    
sql server 2008 (2)    
identity property (1)    
implicit conversion (1)    
null (1)    
optimization (1)    
string (1)    
uniqueidentifier (1)    
varchar (1)