First, the schema does not change frequently. I have used the scripting method at times. I am actually not sure what I would like to arrive at is possible....

This may help, I believe there was an episode of Ray Bradbury Theater which was quite similar to this story description, perhaps it was an adaptation, which would give you...

If you enjoy the healthcare field, it would be likely your last ten years of experience in the industry would help offset some of the inexperience in SQL. Understanding the...

"When I do Select * from TESTVIEW where ID = 123 it takes ~44 seconds.

When I just run the ad-hoc T-SQL code in the VIEW it take < 1 second"

Boris,...

Why thank you Jeff!

It is amazing how fast and what a person can learn about SQL, technology and business in general when in the near worst case scenario most...

Yes, but I am nearly in the victory position now. This week ends the contract with the 4th DBA consultant they hired to come in to prove that the way...

Sadly the reason I don't use SSIS is an IT political one. By sticking to as much version independent TSQL and pure stored procs as I can, I am not...

The 95% of the time where I would use this, and find it useful, is connected to the bcp utility. Frequently users need to be able to run a...

Great!

Thanks Grant.

After years of arguing we finally are having a real go through effort at addressing all the various DB issues we have, and to arrive at standards and so...

Bruce, that was what I was originally considering, a split across function area. I am concerned when such a split is done upon the same underlying hardware the performance gain...

Thanks all, great information!

It does appear to me to be I/O as the problem for the most part, with some network traffic issues as well. From...

Paul - Thank you! That confirms what I was thinking on how the virtualization would/should work. Which helps me determine the best place of focus.

Jeff - Thanks as well!...

Thanks!

I don't have a direct plan of any sort yet, I am looking to get the information and options first.

I was thinking the same with regards to the...

This one was used by the actor who voiced 'Gollum' in the Lord Of the Rings movie, his voice was being trashed badly. I have used it frequently and...

So I do admit, it took alot of self control to not do the I told you so thing. That group already is stunningly uncooperative with me. (Enough so...