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

Content with tag data types Rss

   Items 1 to 20 of 60    Next 20 >>
 

Converting Large Object Data Types

Eliminate pesky legacy TEXT, NTEXT and IMAGE data types with this handy script.  Read more...
By Othman Hack 2013/05/14 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 3,804 reads

Exploring the Varbinary Type

A brief look at the Varbinary data type and its uses in SQL Server for beginners.  Read more...
By Timothy A Wiseman 2013/02/07 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 5,367 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,420 reads

SQL Server Data Type Precedence

I am executing a simple query/stored procedure from my application against a large table and it's taking a long time to execute. The column I'm using in my WHERE clause is indexed and it's very selective. The search column is not wrapped in a function so that's not the issue. What could be going wrong?  Read more...
By Additional Articles 2012/09/04 | Source: MSSQLTips.com | Category: data types
Rating: (not yet rated)  Rate this |   Briefcase | 2,068 reads

SQL Server 2008 R2 Data Types

A list of SQL Server 2008 R2 Data Types and Storage Sizes.  Read more...
By Kenneth Fisher 2012/02/22 | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 3,346 reads

Exact and Approximate

By Paul White 2012/01/03 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 2,385 reads

Data Typing Quandry

By Robert Davis 2010/11/17 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 3,081 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,377 reads

A question on Data Types

By Suresh Babu Kari 2010/02/25 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 3,812 reads

Date and Time

By Steve Vassallo 2009/12/01 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 3,877 reads

Varchar or Char?

By John Arnott 2009/10/16 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,952 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,377 reads

data type precedence!

By VM-723206 2009/08/24 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 3,737 reads

char to datetime!

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

char and varchar!

By VM-723206 2009/07/02 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 4,751 reads

Data Type

By VM-723206 2009/07/01 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 4,945 reads

get real!

By VM-723206 2009/06/26 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 4,390 reads

Access

By VM-723206 2009/06/25 | Category: access
Rating: (not yet rated) |  Discuss |   Briefcase | 4,282 reads

Data types

By VM-723206 2009/06/18 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 4,085 reads

Creating User-Defined Data Types - SQL School Video

Learn how you can create your own data types in this SQL School video. MVP Andy Warren explains the process of setting up user-defined data types.  Read more...
By Andy Warren 2009/06/18 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 3,272 reads
   Items 1 to 20 of 60    Next 20 >>
 
Tags
t-sql (14)    
database design (11)    
sql server 2008 (11)    
sql server 2005 (3)    
performance tuning (2)    
spatial data (2)    
strategies (2)    
varchar(max) (2)    
video (2)    
access (1)    
administration (1)    
basics (1)    
beginner (1)    
columns (1)    
data compression (1)    
date manipulation (1)    
datetime manipulation (1)    
filestream (1)    
hierarchyid (1)    
identifiers (1)    
identity property (1)    
miscellaneous (1)    
money (1)    
naming standards (1)    
ntext (1)    
sparse columns (1)    
sql server 2008 r2 (1)    
sql server 7 (1)    
sys.columns (1)    
sys.systypes (1)    
sys.tables (1)    
timestamp (1)    
uniqueidentifier (1)    
user-defined data types (1)    
varbinary (1)    
varchar (1)    
xml (1)