SQL Server 2005 - Simon Sabin UK SQL Consultant's Blog

Browse by Tags

All Tags » SQL Server 2005 (RSS)
11 March 2010 20:20

SSIS - XML Source Script

The XML Source in SSIS is great if you have a 1 to 1 mapping between entity and table. You can do more complex mapping but it becomes very messy and won't perform. What other options do you have? The challenge with XML processing is to not need a...
Posted by simonsabin | 1 comment(s)
Filed under: , , , , ,
20 January 2010 23:30

XML Validation in SQL Server Intergration Services

I've been workig with XML in SQL Server Integration services this week and to say the XML task in SQL Server Integration services sucks is an understatement. Its buggy, the documentation is woefully inadequate in some cases wrong. I believe this was...
Posted by simonsabin | 2 comment(s)
Filed under: , , , ,
14 January 2010 19:21

User defined function performance is awful, Micorosft please sort this out

User defined functions looked like something great when they were introduced in SQL 2005. They are a very logical step to make more code reuseable by wrapping common code in functions. It is an approach that is in development 101 and something everyone does and looks to doing.

So what is the problem with SQL Server.

Well the issue is that ......

...
Posted by simonsabin | 5 comment(s)
Filed under: , , , , , , , ,
18 August 2009 21:44

SQL Bits session subsmission

Don't forget to submit sessions for SQLBits V in November.

For anyone that hasn't spoken before, as a speaker you will get....

...
Posted by simonsabin | with no comments
Filed under: , , , , ,
10 March 2009 21:52

A significant part of sql server process memory has been paged out

Do you have the following occuring on your SQL Server system. If so it is likely you are running SQL Server 2005 or SQL Server 2008 Standard edition on x64 hardware. It will be causing you serious performance issues when it occurs, as all your database...
Posted by simonsabin | 1 comment(s)
Filed under: , , , ,
09 March 2009 20:46

Enforcing parent child relationship with Path Hierarchy model

With the classic adjacency model its dead easy to validate that a parent exists, its a bit more difficult with path model. The adjacency model you have a table with a self join you can easily add a foreign key between the two columns. When you store a...
Posted by simonsabin | with no comments
Filed under: , , ,
03 November 2008 21:48

TSQL Scalar functions are evil.

I’ve been working with a number of clients recently who all have suffered at the hands of TSQL Scalar functions. Scalar functions were introduced in SQL 2000 as a means to wrap logic so we benefit from code reuse and simplify our queries. Who would be...
Posted by simonsabin | 7 comment(s)
Filed under: , , , ,
28 October 2008 16:44

How to make an HTML table version 2

I posted yesterday about a generating an HTML table. Overnight I had a think as I wasn't happy with the UNION ALL bit of the query and realised you could use sub queries instead. So here is the simplified version. NoteL I've changed the * for...
Posted by simonsabin | with no comments
Filed under: , , ,
28 October 2008 10:53

Some date functions - just date no time, last day of month, first day of month, first day of week and last day of week

The following are a set of scripts to return specific dates relative to the current date. The trick is to get dates with no time, that's easy in SQL 2008 because you can do cast ( sysdatetime () as date ) Annoyingly there is no " System function...
Posted by simonsabin | 1 comment(s)
Filed under: , ,
26 October 2008 22:13

Creating an HTML table from SQL

There used to be a stored proc you could use to create an HTML table from a query. The only time I came across this was on a training course 8 years ago and then I didn't see the point. With the introduction of XML support in SQL it's eay to create...
Posted by simonsabin | with no comments
Filed under: , ,
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 | 6 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 | 14 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'...
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...
Posted by simonsabin | 4 comment(s)
Filed under: ,
More Posts Next page »