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

Articles with tag Data Types Rss

Search for any content tagged data types

   Items 1 to 20 of 38    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,641 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

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,523 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

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

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

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,619 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,278 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 | 863 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: data types
Rating:  Rate this |   Briefcase | 4,191 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,396 reads

Super Sizing Columns in SQL Server

This article describes how to work with large objects in SQL Server using the MAX Specifier  Read more...
By Additional Articles 2008/11/05 | Source: SQL Server Performance | Category: data types
Rating:  Rate this |   Briefcase | 2,298 reads

SQL Server 2008: The New Data Types

Brad continues his helicopter-level view of the most important new features of SQL Server 2008 with a look at the new data types, their use and their significance.  Read more...
By Additional Articles 2008/10/31 | Source: SimpleTalk | Category: sql server 2008
Rating:  Rate this |   Briefcase | 3,388 reads

Auto generated SQL Server keys - uniqueidentifier or IDENTITY

I'm designing a table and I've decided to create an auto-generated primary key value as opposed to creating my own scheme or using natural keys. I see that SQL Server offers globally unique identifiers (GUIDs) as well as identities to create these values. What are the pros and cons of these approaches?  Read more...
By Additional Articles 2008/10/23 | Source: MSSQLTips.com | Category: t-sql
Rating:  Rate this |   Briefcase | 4,968 reads

The Many Benefits of Money…Data Type!

Our initial reason for looking at the money data type can be found within the Precision Considerations for Analysis Services Users white paper. In this white paper, we provide extensive examples of the types of precision issues when your SQL relational data source and your Microsoft® SQL Server® Analysis Services cube have different non-matching data types (e.g., if you query one way you get the value 304253.3251, but run the query in another way and you get the value 304253.325100001).  Read more...
By Additional Articles 2008/10/02 | Source: Microsoft MSDN | Category: data types
Rating:  Rate this |   Briefcase | 2,685 reads

SQL Server 2008: new data types and .Net 2 with and without SP1

If you use the new data types in SQL Server 2008, and your front-end application uses .NET 2, you may hit difficulties. András explains why and how...  Read more...
By Additional Articles 2008/07/10 | Source: SimpleTalk | Category: sql server 2008
Rating:  Rate this |   Briefcase | 3,066 reads
   Items 1 to 20 of 38    Older >>