Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 | 6,036 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 | 318 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,926 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,611 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,226 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,529 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,492 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,560 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 | 6,012 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,896 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,311 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,680 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,529 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,670 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,670 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,899 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,362 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 | 1,017 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,324 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,480 reads
   Items 1 to 20 of 43    Older >>