Adam Machanic (4/27/2009)

---

Hi all,

I have posted a more scalable SQLCLR string split method here:

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

Thanks to Paul White for pointing me to this thread. Please consider testing all of these...

john.moreno (4/27/2009)

---

This example is based on actual SQL code written by a developer (who shall remain anonymous) who was exceptionally proud to have figured out this entire routine on his...

Another good article Barry. I look forward to part 3 as we are starting to get to the "meat".

No problem. Depending on when you get it done I may even have 2008 on a server that I can play with!

Jeff,

If you send me the test code I can run it in 2008. I have it on my laptop.

I don't know of anyway to add a scroll bar, and I can give you an idea to add a page break after N rows.

You can create a group(you don't...

In the past I've looked using all the common job sites, but at this point in my career I would use my network to try to a position. Thus...

I would create a server-side trace that filters on the database that I am concerned with.

Lowell won, with a script example as well.

So what are your groups? Can you post some sample data that I and others can play with? And the query you are using to populate the dataset?

I took a couple of minutes to load up the AdventureWorks database Product and SalesOrderDetail tables with 100,000 and 1,000,000 rows respectively followed by update statistics full scan and then...

David (4/24/2009)

---

Jack, I won't speak for the OP, but I recently did something along the same lines, where the database name had to be generated dynamically to save me a...

If you check out the articles I reference you will see the reason(s) why. Mainly because the log grew to that size for a reason so it will likely...

You can try a couple of things to reduce the pain: