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

Articles with tag DataTypes Rss

Search for any content tagged datatypes

   Items 1 to 20 of 43    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,787 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 | 298 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,807 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,424 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,204 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,459 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,381 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,544 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: datatypes
Rating: |  Discuss |   Briefcase | 5,960 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,763 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: datatypes
Rating: (not yet rated)  Rate this |   Briefcase | 2,249 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,649 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,459 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,620 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,620 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,786 reads

Using the Timestamp Data Type - SQL School Video

The timestamp data type is a unique data type in SQL Server. Brian Knight shows how it can be used in your tables.  Read more...
By Brian Knight 2009/01/29 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,327 reads

Temporal Datatypes in SQL Server

In the first of a series of articles on the tricks of tackling temporal data in SQL, Joe Celko discusses SQL's temporal data types and agonizes over the fact that, although there are ANSI/ISO Standards for temporal operations in SQL, every vendor has something different.  Read more...
By Additional Articles 2008/12/31 | Source: SimpleTalk | Category: datetime manipulation
Rating: (not yet rated)  Rate this |   Briefcase | 925 reads

Data Types in SQL Server 2008

Don Schlichting compares and contrasts the various SQL Server 2008 Data Types. In addition, he explores which Data Types are the best solutions for specific situations.  Read more...
By Additional Articles 2008/12/10 | Source: Database Journal | Category: datatypes
Rating:  Rate this |   Briefcase | 4,235 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,447 reads
   Items 1 to 20 of 43    Older >>