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

Content with tag DataTypes Rss

   Items 1 to 20 of 81    Older >>
 

The Case for Specifying Data Types and Query Performance

Performance penalties for omitting SQL data types when using ADO.Net or light weight ORMs.  Read more...
By Chad Feghali 2015/06/22 | Source: SQLServerCentral.com | Category: ado.net
Rating: |  Discuss |   Briefcase | 5,864 reads

Numeric Data Types

By Orlando Colamatteo 2015/05/05 | Category: data modeling
Rating: (not yet rated) |  Discuss |   Briefcase | 1,756 reads

Approximate Data types

By lalit y 2015/02/16 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,777 reads

The Number that shouldn't be a number

Gail Shaw is often left bewildered by the weird and wonderful data types people choose for their tables, when storing something as simple as a telephone number or a date.  Read more...
By Gail Shaw 2015/02/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 301 reads

Identity Data Types

By Steve Jones 2015/01/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,267 reads

All datatypes basics in SQL Server 2008R2.

What is completed datatypes in sqlserver and how it works in Real time.  Read more...
Rating: |  Discuss |   Briefcase | 1,413 reads

Comparing SQL Server Datatypes, Size and Performance for Storing Numbers

When more than one numeric SQL Server data type may be suitable for a field in a project, which data type should you choose and what are the implications for SQL Server performance?  Read more...
By Additional Articles 2014/09/16 | Source: MSSQLTips.com | Category: datatypes
Rating: (not yet rated)  Rate this |   Briefcase | 8,819 reads

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: datatypes
Rating:  Rate this |   Briefcase | 17,438 reads

Casting and Data Type Conversion

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

SSIS Column Export

By Andy Warren 2014/07/09 | Category: integration services (ssis)
Rating: (not yet rated) |  Discuss |   Briefcase | 2,010 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: datatypes
Rating: |  Discuss |   Briefcase | 6,205 reads

Filetable paths

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

Datatypes In Your Mind

By Andy Warren 2014/05/06 | Category: datatypes
Rating: (not yet rated) |  Discuss |   Briefcase | 2,095 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: datatypes
Rating: |  Discuss |   Briefcase | 1,173 reads

Disk Is Cheap! ORLY?

People often conclude that the cheap price of storage is a license to use as much as possible, but there is a cost.  Read more...
By Solomon Rutzky 2013/10/25 (first published: 2010/12/31) | Source: SQLServerCentral.com | Category: data-modeling
Rating: |  Discuss |   Briefcase | 13,467 reads

Filestream data

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

LEN and CONVERT

By Kapil Singh 2013/07/30 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,893 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: datatypes
Rating: (not yet rated)  Rate this |   Briefcase | 3,389 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: datatypes
Rating: |  Discuss |   Briefcase | 4,545 reads

Data Type

By Yogesh Kumar 2013/05/10 | Category: null
Rating: (not yet rated) |  Discuss |   Briefcase | 2,191 reads
   Items 1 to 20 of 81    Older >>
 
Tags
t-sql (21)    
database design (12)    
sql server 2008 (11)    
columns (3)    
performance tuning (3)    
sql server 2005 (3)    
filestream (2)    
identity property (2)    
image (2)    
ntext (2)    
spatial data (2)    
strategies (2)    
varchar(max) (2)    
video (2)    
access (1)    
administration (1)    
ado.net (1)    
alter (1)    
basics (1)    
beginner (1)    
best practices (1)    
cast (1)    
change column (1)    
data compression (1)    
data modeling (1)    
database weekly (1)    
data-modeling (1)    
date manipulation (1)    
datetime manipulation (1)    
decimal datatype (1)    
development (1)    
editorial (1)    
export column (1)    
filetable (1)    
hierarchyid (1)    
identifiers (1)    
implicit conversion (1)    
integration services (ssis) (1)    
internals (1)    
len (1)    
miscellaneous (1)    
money (1)    
naming standards (1)    
null (1)    
optimization (1)    
sparse columns (1)    
sql server 2008 r2 (1)    
sql server 7 (1)    
sqlparameter (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)