Friday, September 15, 2006 - Posts

Full text Indexing with SQL 2005 - Memory configuration

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Full text Indexing with SQL 2005 - Memory configuration
The new RSS feed is here

We've just bought some nice new servers with buckets of RAM and and plenty of 64 bit CPU power so why is the Full Text Indexing paused because of lack of resources.

Well previously we had SQL 2000 standard edition running on 32 bit servers with 4Gb of RAM. In this case SQL could only take 2Gb and generally only took 1.7Gb leaving a fare amount for Full Text, and in 2000 FT wasn't very memory effecient unless you tweaked some settings.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Full text Indexing with SQL 2005 - Memory configuration

posted Friday, September 15, 2006 6:39 PM by SimonSabin with 1 Comments

Support for varchar(max) with string functions

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Support for varchar(max) with string functions
The new RSS feed is here

You may have read my previous post about string literals and their data types (When is varchar(max) no a varchar(max)) so I knew you had to be careful with the handling of strings if you want to maintain the varchar(max) data type.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Support for varchar(max) with string functions

posted Friday, September 15, 2006 10:21 AM by SimonSabin with 1 Comments