Dang but Adam posts fast!

Here's the link to his blog entry that I was going to post:

http://sqlblog.com/blogs/adam_machanic/archive/2009/04/26/faster-more-scalable-sqlclr-string-splitting.aspx

Jeff is going to love this 😉

Cheers,

Paul

@Phil, Flo:

Probably the easiest way would be to compare your respective .sqlplan actual execution plans for the queries in question, together with the usual CPU and IO information...?

@bruce-2:

Don't get me...

Posting your question about SQL Server 2000 in the 2005 section wasn't the brightest start possible here!

Nevertheless, this is a great place to look for recursive/hierarchical techniques on SQL Server...

Matt helping someone?...

Hey,

It would have helped a great deal had you posted example code.

WITH RECOMPILE at the top of a procedure does not extend to any dynamic SQL run by that procedure.

Adding...

Hey Benn,

Windows 2003 Small Business Edition can use up to a maximum of 4GB RAM - see http://msdn.microsoft.com/en-us/library/aa366778.aspx#physical_memory_limits_windows_server_2003

SQL Server Enterprise with 12GB RAM would need Windows 2003 Enterprise or above.

If...

Hey Mohit,

Sounds like you're doing all you can. My only other thoughts would be to:

1. Ensure that SQL Server has sufficient memory installed so that the data stays...

This wasn't really a CLR Integration and Programming question, was it?

😉

Hey Ian,

Just a quick question before I post a proper reply: how many 'bits' are likely to be set per user?

The relational solution will be much quicker and more maintainable,...

John,

Register the library as an assembly in SQL Server using CREATE ASSEMBLY.

Open the Object Browser in Visual Studio and add or locate the library in there.

Click the button on the...

Andrew,

There too much there to respond to line-by-line, so I would just say:

I have worked in two large international companies now that experimented with ESX virtualization. Neither were conspicuous...

Bob Hovious (4/26/2009)

---

Hey Paul, I followed your link about the new flag. My son has lived in Dunedin for years now, but never mentioned this to me. ...

Florian Reischl (4/26/2009)

---

One of the hobbies of my chief. We have an own string, DateTime, List, DB-Connection, even an own...

A quick post before bed concerning the TVFs posted by Phil.

Unless I am missing something obvious, this solution is heavily dependent on the TVF only being called once.

This is achieved...

andrew.hatfield (4/26/2009)

---

That's a bit of a generalisation - all virtualisation = bad and all san = bad.

It depends on the workload of the environment, it's CPU and Memory footprint as...