Jeff,

The timing I took is, as Barry, a simple

SELECT GETDATE() AS [Before]

followed by a

SELECT GETDATE() AS [After]

precisely to avoid the setup bit and it gives me 3...

Hi Jeff,

I can get better performance by using a function copied from Barry's but I just don't have a clue why it behaves better... which is pissing me off!

If I...

Jeff,

Here is how I defined and populated my Number table.

CREATE TABLE NetFinance.Number(n_Id INT NOT NULL PRIMARY KEY);

GO

DECLARE @max-2 AS INT, @RowCount AS INT;

SET @max-2 = 1000000; -- 1,000,000 rows should...

Sorry for the delay and thanks for answering...

I was still enjoying the weekend!

I'll try to answer the various questions:

1) Why returning just the separators? (Jeff)

I was simply extracting the bit...

This still seems to be missing the point...

The title of this article was "Eliminating Cursors" while it's just "hidding" them.

Cursor are only "bad" because they are processing row by row.

Processing...

I strongly DISLIKE this article because it completely misses the point about cursors...

Like the author, I always use some form of non-cursor based looping if I really have to because...

Yes, I suppose it's a lot easier if the data is already in your database.

I was assuming you were importing it, in which case SSIS could be an option too.

Cheers

🙂

Grasshoper,

Why did you need to use CLR integration?

Could not you have written a "simple" C# console application?

That can also run on the database server and could be more modular...

Or use...

Actually, I have seen one good example.

In the (brilliant) book "Inside SQL Server 2005: TSQL Querying", Itzik Ben-Gan uses two versions of a function that simply manipulates (in a complex...

Maybe we can summarise by saying that integrated CLR is the perfect solution...

but that we are still looking for the problem 😛

Could the answer be simple?

Could it be that it's not that useful anyway!

A bit like cursors :)... Sorry, could not help it!

TSql is very efficient at accessing data, CLR is...

I had forgotten about this one...

Yes, it sounds a very good idea

Thanks 🙂

Although simplistic, I usually like to look at

- Physical Disk / % Disk Time (on each drive if relevant, not for SAN)

- Processor / % Processor Time (on each...

Thanks for these comments guys.

I thought the lack of "human skills" shocking in the ealier definitions.

I have seen many excellent teckies who were far from fantastics because of lack of...

OOPss!

I had probably damaged something in my model as it's working fine now.

(I had assigned my entity to the Primary Key rather than the entire entity... or something like that)

Sorry...