This is the best reference for this problem. As per my personel tests I find the set solution as much as 10 times faster to parse the string compared...

syscolumns.name is a sysname type. This is a "server defined datatype" which uses nvarchar as its base datatype. So you have to cast to make it work.

We already gave our ruling .

You're right about that. However fnSplit_Set clearly tells what the function is for... and select * from dbo.fnSplit_Set() will make it crytal clear. This is a situation where...

Wasn't that obvious ??

I actually hate loops on sql server... and so should everyone else .

You're right SqlBill. But the fact is that I can't do squat about the number of tempdbs that come with the server. It's by design. However I...

IF Object_id('fnSplit_Set') > 0

DROP FUNCTION dbo.fnSplit_Set

GO

IF Object_id('Numbers') > 0

DROP TABLE dbo.Numbers

GO

CREATE TABLE dbo.Numbers (PkNumber int identity(1,1), dude bit null, CONSTRAINT Pk_Number PRIMARY KEY CLUSTERED (PkNumber))

GO

INSERT INTO dbo.Numbers (dude)

SELECT NULL FROM...

Can you fire up the profiler and see that queries take a long time to run?

Alright. HTH.

Sorry :

UPDATE dbo.IISVisite

SET VisDateHeure = CONVERT(datetime, [dbo].[FormatDate](VisDate), 20)

WHERE VisDateHeure IS NULL

btw I don't think you need to convert the values with that function unless you expect bad data... that...

UPDATE dbo.IISVisite

SET VisDateHeure = CONVERT (datetime, [dbo].[FormatDate](@dateSource), 20)

WHERE VisDateHeure IS NULL

We can only offer guesses without more information. If this happens again you'll have to start a trace and see who's running that command. There's pretty much nothing...

Just a hunch... I already built a script that basically drops all the sp one by one and recreates them. The goal of that script was to recreate...

Just a guess :

IF Object_id('fnSplit_Set') > 0

DROP FUNCTION dbo.fnSplit_Set

GO

IF Object_id('Numbers') > 0

DROP TABLE dbo.Numbers

GO

CREATE TABLE dbo.Numbers (PkNumber int identity(1,1), dude bit null, CONSTRAINT Pk_Number PRIMARY KEY CLUSTERED (PkNumber))

GO

INSERT INTO...

You can set the format in the textbox directly which seems to work much faster (probably because it's done only when data is requested on the screen).