Browse by Tags

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 to do it was, he had addresses in one field he wanted...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 03-17-2008
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 realy useful you would want to...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 02-15-2008
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 as it only reads one row rather than having to...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 11-06-2007
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 of these values is to the second. When you've...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 09-25-2007
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 me get it to load. After much digging I realised...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 09-22-2007
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 one returns text version. The functions are DATEPART...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 09-03-2007
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 a great response which I've got his permission...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 08-16-2007
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 in the service release and the dependecy...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 08-16-2007
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 merge you have 3 boundaries the left one, the middle...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 07-31-2007
SQL Server - TCP/IP Ports

Personally I think networks are a black art, I think there are probably less network admins that there are DBAs in the world. As for diagnostics and tools for network configuration, as a SQL Server person I feel I now know what its like configuring and running Oracle. My latest venture into networks...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 07-30-2007

Page 1 of 6 (59 items) 1 2 3 4 5 Next > ... Last »