SQLServerCentral: Content tagged T-SQL, Data Types

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

Data Typing Quandry

By Robert Davis 2010/11/17 | Category: data types

Rating: (not yet rated) |

Discuss |

Briefcase | 3,083 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,377 reads

Varchar or Char?

By John Arnott 2009/10/16 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 4,952 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,377 reads

char to datetime!

By VM-723206 2009/08/19 | Category: data types

Rating: (not yet rated) |

Discuss |

Briefcase | 4,051 reads

decimal

By VM-723206 2009/06/17 | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 4,608 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,298 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: