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 71    Older >>
 

13 Questions about SQL Server Data Types You were Too Shy to Ask

Although SQL Data Types seem to cause a lot of grief for database developers and can be tricky in their use, we seem to be expected to know all about them, and so it is embarrassing to ask questions about them in forums. Rob Sheldon continues in his mission to answer all those questions that we hesitate to ask.  Read more...
By Additional Articles 2014/07/21 | Source: SimpleTalk | Category: data types
Rating:  Rate this |   Briefcase | 14,627 reads

Casting and Data Type Conversion

By Jason Whitish 2014/07/15 | Category: cast
Rating: (not yet rated) |  Discuss |   Briefcase | 1,982 reads

SSIS Column Export

By Andy Warren 2014/07/09 | Category: integration services (ssis)
Rating: (not yet rated) |  Discuss |   Briefcase | 1,861 reads

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,126 reads

Filetable paths

By Steve Jones 2014/05/13 | Category: filetable
Rating: (not yet rated) |  Discuss |   Briefcase | 1,459 reads

Datatypes In Your Mind

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

Identify Column Data Types

Use the following queries to list a result set of all column data types to any specified database. In the 2nd query, you will see a result set based on all text based data type columns in your database (XML data type not included). Modify accordingly.  Read more...
By Rich Yarger 2014/04/07 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 1,107 reads

Filestream data

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

Security for SQL Server User Defined Data Types

I have a group of developers that I support and they are reporting they cannot see columns within their tables. I have granted them db_datareader permissions which is a standard at my company for QA environments. Why can't they see their column definitions? Check out this tip to learn more.  Read more...
By Additional Articles 2013/07/12 | Source: MSSQLTips.com | Category: data types
Rating: (not yet rated)  Rate this |   Briefcase | 3,240 reads

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 | 4,522 reads

Data Type

By Yogesh Kumar 2013/05/10 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 2,140 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,898 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,647 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,179 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,583 reads

Exact and Approximate

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

Generate alter datatype script for entire database

ntext, text, and image (Transact-SQL). This script will alter the data type from image to varbinary(max) which is very much required as the data type is out of support.  Read more...
By Venugopal Saride 2011/11/28 | Source: SQLServerCentral.com | Category: ntext
Rating: |  Discuss |   Briefcase | 817 reads

Data Typing Quandry

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

A question on Data Types

By Suresh Babu Kari 2010/02/25 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 3,859 reads
   Items 1 to 20 of 71    Older >>
 
Tags
t-sql (18)    
database design (11)    
sql server 2008 (11)    
performance tuning (3)    
sql server 2005 (3)    
columns (2)    
filestream (2)    
image (2)    
ntext (2)    
spatial data (2)    
strategies (2)    
varchar(max) (2)    
video (2)    
access (1)    
administration (1)    
alter (1)    
basics (1)    
beginner (1)    
cast (1)    
change column (1)    
column (1)    
data compression (1)    
date manipulation (1)    
datetime manipulation (1)    
export column (1)    
filetable (1)    
hierarchyid (1)    
identifiers (1)    
identity property (1)    
implicit conversion (1)    
integration services (ssis) (1)    
miscellaneous (1)    
money (1)    
naming standards (1)    
null (1)    
optimization (1)    
sparse columns (1)    
sql server 2008 r2 (1)    
sql server 7 (1)    
string (1)    
sys.columns (1)    
sys.systypes (1)    
sys.tables (1)    
text (1)    
timestamp (1)    
tips & tricks (1)    
uniqueidentifier (1)    
user-defined data types (1)    
varbinary (1)    
varchar (1)    
xml (1)