Browse by Tags

All Tags » Full Text (RSS)
13 June 2011 12:40

SQL Azure Federations and Semantic Search by the SQL product team in London tonight (Monday)

Don’t forget that tonight we have Michael Rys from the SQL Server Product Team presenting on the Federation support coming to SQL Azure and the Semantic search coming in SQL Server Denali. This is a must attend evening for anyone that is serious about...
Posted by simonsabin | 1 comment(s)
Filed under: , , , , , ,
30 January 2011 14:12

Entity framework support for table valued functions and thus full text

One of my most popular posts with over 10, 000 hits is how to enable full text when using LINQ to SQL http://sqlblogcasts.com/blogs/simons/archive/2008/12/18/LINQ-to-SQL---Enabling-Fulltext-searching.aspx , core to this is the use of a table valued function...
Posted by simonsabin | 2 comment(s)
Filed under: , , , , ,
11 April 2008 16:27

SQL Server 2008 - Breaking bug

If you are using CTP6 of SQL Server 2008 and want to use Integrated Full Text and find it is not working. You might get timeouts or other general errors. It could be due to an account that iFTS uses. iFTS does some stuff out of process for security and...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
20 February 2008 13:06

SQL Server 2008 – iFTS Performance – DocidMap

The next post in the series on iFTS (Integrated Full Text Search) covers one of the major improvements in SQL Server 2008 for Full Text and is related to the Integrated part or iFTS. SQL Server 2005 introduced a huge performance improvement by moving...
Posted by simonsabin | 9 comment(s)
Filed under: , , ,
20 February 2008 12:11

SQL Server 2008 – iFTS Manageability – Loading thesaurus files

The next post in the series on iFTS (Integrated Full Text Search) covers a thesaurus files. A feature introduced in SQL 2005. The loading of thesaurus files is a bit of an uncontrolled beast in SQL Server 2005 (there weren’t supported or documented prior...
Posted by simonsabin | 3 comment(s)
Filed under: , , ,
20 February 2008 11:32

SQL Server 2008 – iFTS Transparency – Viewing the words in the index

This is the next in the series of posts about the new iFTS (Integrated Full Text Search) in SQL Server 2008. One of the huge frustrations with using Full Text prior to SQL Server 2008 was that you had no idea what content the iFilter has extracted from...
Posted by simonsabin | 3 comment(s)
Filed under: , , ,
20 February 2008 09:40

SQL Server 2008 – iFTS Transparency – dm_fts_parser

SQL Server 2008 – iFTS Transparency – dm_fts_parser In the next in this series of posts on Integrated Full Text Search (iFTS) in SQL Server 2008, we look at the new dmv dm_fts_parser. Wow thats a cool function name what does it do Simon? Well in my first...
Posted by simonsabin | 5 comment(s)
Filed under: , , ,
20 February 2008 09:38

SQL Server 2008 – iFTS New features

In the previous post I talked about Full Text in general. I will now talk about whats new in SQL Server 2008. I would categorise the new features into Performance, Manageability and Transparency. So what’s new in SQL Server 2008, well we have, 1. Full...
Posted by simonsabin | 6 comment(s)
Filed under: , ,
19 February 2008 17:52

SQL Server 2008 - CTP6 is now available

The next CTP of SQL Serve 2008 is now available for download. Whats different about this CTP from the others, apart from the new features which there are a lot, is there is a bug bash contest that is opening. Simply put the people that raise the most...
Posted by simonsabin | with no comments
Filed under: , , , ,
19 February 2008 15:06

SQL Server 2008 – iFTS Introduction

This is the first of a series of posts on the new Integrated Full Text feature in SQL Server 2008. This is one of my favourite features which I’ve had to keep stum about for quite a while. Firstly an introduction to full text. Full text is the feature...
Posted by simonsabin | 16 comment(s)
Filed under: , ,
More Posts Next page »