Browse by Tags

All Tags » CTP (RSS)

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...

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...

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...

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)

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...

SQL Server 2008- What is a spatial reference?

A friend recently emailed me after trying out the new spatial stuff in Katmai asking why the distance from Beaverton to Boston was 51, and any way 51 what. On looking at his code I realised he had used the Geometry type and not the Geography type. The...
Posted by simonsabin | with no comments
Filed under: , ,

Katmai - Connecting from SQL2005

UNfortunately you canot connect from SQL2005 to SQL 2008 (Katmai) from management studio, or can you. It appears the validation code is in the main connection dialog. However if you use SQLCMD mode you will be fine. So connect to you SQL2005 server and...
Posted by simonsabin | with no comments
Filed under: , ,

SQL Server 2005 Service Pack 2 CTP - Downloads

If like be you're eager to try the new features in SP2. The following are the direct links for the CTP, What's New doc Upgrade Pkg x86 Upgrade Pkg x64 Upgrade Pkg ia64 Express (core) x86 Express Advanced x86 Express Toolkit x86 The full details...