Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

Uni-code

1
July 21, 2008  11:00 AM

A better way to index text data



Posted by: Denny Cherry
Index Performance, Query tuning, SELECT statement, T/SQL, Tables, Uni-code

Indexing text data (varchar, nvarchar, char, etc) is a good way to make it faster to find the data you are looking for.  However these indexes can end up being very hard on the disks behind the index, as well as the memory of the server.  This is because of the large amount of data being put in...

  Bookmark and Share     2 Comments     RSS Feed     Email a friend

November 28, 2007  7:38 AM

What’s up with the N in front of string values?



Posted by: Denny Cherry
Data Types, SQL, Uni-code

If you have looked at pretty much any Microsoft provided T/SQL code you have probably seen an N in front of a string value when setting a variable much like this. SELECT * FROM...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

November 26, 2007  7:35 AM

Should I be using uni-code data types?



Posted by: Denny Cherry
Data Types, SQL, Uni-code

The path that Microsoft is going says yes.  They are moving all there samples and defaults to using uni-code.  In reality uni-code may not be needed in your environment.  If you are storing only Latin characters (the US alphabet characters) then you probably don't need to store uni-code...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1