Thanks.

The real issue is disk I/O bottlenecks.

Among issues...

Raid5

tempdb, translogs, and dbs on the same disks.

antivirus software running in real time, constant run that is.

There are more, but are mostly obscured...

Thank you for the replies.

I actually do know, myself, what the issue really is, and have all sorts of books, articles, traces, stats to back it up. All...

Jack Corbett (12/26/2008)

---

David Lester (12/26/2008)

---

Jack Corbett (12/9/2008)

---

Looks like someone to some persons fell in love with UDF's.

Developer1 - "Hey why write it over and over again, we can...

Jack Corbett (12/9/2008)

---

Looks like someone to some persons fell in love with UDF's.

Developer1 - "Hey why write it over and over again, we can encapsulate it in a...

The eye! Of course, and here I thought it might be the lab coat and the hunchback ....

Hey, thanks Jeff!

Great info in the article... now to find some spare time to try to adapt that.

There are times I want regular SQL experiment times here. (my...

Ahh the joys of working with a poorly designed vendor software! (Watch out for that puddle of sarcasm...) Apparently they designed the note fields on the width of the screen...

We will be upgrading eventually to SQL2005, though it does not seem to be on any high priority list.

I was starting to think the way to do this might end...

As I look at the data I think I will be putting the result into a text data type, it is plausible that the data could grow beyond a varchar(8000)....

Oohhh, yes Gail, that helps alot.

I will get a listing of those stats fairly soon here, as time allows for me to do so.

Thanks!

Steve, that is the idea which was just going through my mind.

Thanks!

Thank you for the answers so far. It is actually not a reporting services server, just a data warehouse, so the first suggestion won't work.

Gila, I had considered a code...

Thanks! I had not thought about using an identity column, that was my sticking point, finding how to match to the prior row.

Wow, looks like people were busy here.

Jeff, and all..

I have the code working as I expect it to. Not as a copy paste of what is here of...

Heh, yea its a project I have to do for governement regulations, however, the government chooses to analyze the data contrary to its actual use. Infact the database is...