SQL Server 2008 - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » SQL Server 2008 (RSS)
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: , , ,
31 March 2008 10:13

SQL Server 2008 - HierarchyId - How do you move nodes/subtrees around

In a recent post SQL Server 2008 - HierarchyId whats the point? I talk about the scenarios that the new hieararchyId can be applied to. Here we expand on this further and also provide a solution for moving hierarchies around. The limitation is that you...
Posted by simonsabin | 2 comment(s)
Filed under: , , ,
29 March 2008 23:40

SQL Server 2008 - HierarchyId whats the point?

I've recently been deliverying training sessions on SQL Server 2008 and doing launch events. The training covers all aspects of SQL Server development. For most features I can provide a strong argument for the feature with the exception of one. HierarchyId...
Posted by simonsabin | 1 comment(s)
Filed under: ,
16 March 2008 21:21

SQL Server 2008 - Whats this abut 30,000 columns?

Its all about Sparse columns and they are a great feature of Katmai Imagine you have a products table, you will have attributes for some products that don't apply to others i.e. cup size applies to bras but not to socks. There are a number of ways...
Posted by simonsabin | 2 comment(s)
Filed under: , , ,
11 March 2008 11:51

SQL Server 2008 - Converting binary(hex) values to strings

One of the frequently asked questions in the newsgroups is how do you convert a string representation of a binary value to the equivalent binary value and the reverse. The latter is often required to be able to print out the binary representation. There...
Posted by simonsabin | with no comments
Filed under: , ,
05 March 2008 12:12

SQL Server 2008 - ISDATE doesn't work with

I really don't understand this. The ISDATE function doesn't work with new date and time types, whats more you can't pass it a string representing a date before 1/1/1753. Try this select ISDATE('1/1/1700') in SQL 2008 it will return 0. Whats odd is that...
Posted by simonsabin | with no comments
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 | 3 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 | with no comments
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 | with no comments
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 | with no comments
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 | 2 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 | 6 comment(s)
Filed under: , ,
11 February 2008 12:23

UK SQL Usergroup meeting in London - 21st Feb

Last year we promised more usergroup meetings and hopefully this year we will deliver. I have now arranged to have a user group meeting every 3rd Thursday of the month. We will be starting off in London on the 21st of February and then alternating between...
Posted by simonsabin | 1 comment(s)
Filed under: , ,
21 January 2008 12:04

Whats the most annoying error message?

Very very high up on my list has to be "String or binary data would be truncated." Error 8152. Why is this annoying? Because you have no idea which column it is referring to. On recently encountering this again I looked to see if anyone had asked for...
Posted by simonsabin | with no comments
Filed under: ,
More Posts Next page »