SQL Server 2005 - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » SQL Server 2005 (RSS)
17 March 2008 16:52

Set based splitting of delimited strings to columns

I recently presented on using CLR in SQL at DevWeek and commented on how TSQL Udfs just don't perform. A common scenario people in the audience were using TSQL Udfs for was splitting delimited strings. One guy asked me afterwards what the best way...
Posted by simonsabin | 3 comment(s)
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: , ,
15 February 2008 10:56

Table Valued Methods on Type

I amd really getting into the use of UDTs as a way of packaging up SQL CLR code. I'm also looking into implementing an array type so I can do code like declare @s dbo . SQLArray set @s . AddKeyword ( 'sas' ) set @s . AddKeyword ( 'dog' ) Fo this to be...
Posted by simonsabin | with no comments
Filed under: , ,
18 December 2007 23:08

Office 2007 iFilters are now available

The ifilters needed to index office 2007 documents are now available for download from here http://www.microsoft.com/downloads/details.aspx?FamilyId=60C92A37-719C-4077-B5C6-CAC34F4227CC&displaylang=en At the time of writing some of the related KB...
Posted by simonsabin | with no comments
Filed under: , , , ,
12 November 2007 15:17

Should you wait for Katmai.

I read Steve Jones editorial in Database Weekly today and saw his statement. " I still recommend jumping from 2000 to 2008 if you haven't already upgraded" My personal view is that if you are looking to replace your systems then 2005 has some great features...
Posted by simonsabin | 4 comment(s)
Filed under: ,
08 November 2007 08:40

Performance Point RTM is now available

I got an email from MS today saying the Performance Point RTM is now generally available. Performance point is something I am interested in but as with many new technologies I have yet to dedicate any time to picking it up. If you are interested in learning...
Posted by simonsabin | 1 comment(s)
Filed under: , ,
06 November 2007 21:50

Is the rows figure stored in sysindexes accurate

It wasn't guaranteed to be in SQL 2000 and earlier, but work was done in SQL 2005 that should mean that the rows figure stored in sys.partitions should be accurate. Madhivanan has posted about the different ways to count rows and this is the quickest...
Posted by simonsabin | 2 comment(s)
Filed under: , ,
25 September 2007 21:33

SSIS Dates aren't very precise

I'm implementing some SSIS packages at the moment and started looking at logging with the event handlers. I simply wanted task start and end times etc and so used the start time system variables. What I noticed when I ran reports was that the accuracy...
Posted by simonsabin | 1 comment(s)
Filed under: , ,
22 September 2007 23:00

Full text thesaurus files bug in documentation

I don't normally blog about documentation errors generally because they're often not that major however this one is fundamental what is being explained. This is the page online http://msdn2.microsoft.com/en-us/library/7f5424a4-a72c-44dc-b455-786a12767c99...
Posted by simonsabin | with no comments
Filed under: , ,
22 September 2007 22:51

XmlTextWriter produces processing instruction

This week I've been producing XML Thesaurus files for SQL Server. The prupose is to enable spell checking in full text. The thesaurus file is an XML file wih a defined schema, I was creating the file with an XmlTextWriter but couldn't for hte life of...
Posted by simonsabin | with no comments
Filed under: , ,
03 September 2007 22:44

How to get the name of the day of date

Do you have a date and you want the day of the week but not the number but the name i.e. Monday, Tuesday etc. Well there are two functions that you can use with dates that can be used to extract a part of the date. One function returns the number and...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
16 August 2007 22:44

Whats in a BOL link?

In using BOLyou will have noticed that the links in BOL contain some lovely guids. I often want to reference BOL in documents, forum posts etc but was concerned that the guids might change. So I asked Alan Brewer whether they change or not. He gave me...
Posted by simonsabin | 1 comment(s)
Filed under: , , , ,
16 August 2007 22:13

Data Dude : Database Documentor

If you want to document your database you've got to see Gert Drapers on Channel9. Data Dude is answering so many of those questions/challenges I've been trying to solve for database builds over the past decade. I am so pleased to see the database references...
Posted by simonsabin | with no comments
Filed under: , ,
15 August 2007 21:57

How big is your procedure cache?

There have been continuing reports by most people I speak to about theire procedure cache becoming huge. Especially on 64 bit systems with lots of memory. Memory that you want for your data. The issue is due to the storinging of compiled adhoc plans....
Posted by simonsabin | 3 comment(s)
Filed under: , ,
31 July 2007 23:10

How to speed up partition merging

The key to performance with partition management is to deal with empty partitions. That way all you have is meta data changes and no data has to be copied. We recently encountered a situation where we had two partitions and wanted to merge them. In a...
Posted by simonsabin | with no comments
Filed under: , , ,
More Posts Next page »