Thanks Paul, I had not considered placing them is separate file groups. I'll need to explore this more.

Steve

Thanks for your reply Steve. I tend to agree with you about not re-inventing the wheel here. Our Perl app is actually quite sophisticated in how it handles deploying the...

Thanks for your answers. There are some cases where the data needs to be shared (aggregations of clients) but in some cases not. Depends on the level and version of...

Barry, the OS is XP and SQL Server is 2005 SP2, details below, thanks.

Note that I am seeing the same behavior on our staging server which is W2K3.

Microsoft SQL Server...

Thanks Grant for your observations. That is what I am working on, getting control of the indexes. The tuning adviser recommended the covering index which sped up the view based...

Forgot the insert...

INSERT INTO [StudentServices]

([ID]

,[StudentID]

...

Here is the DDL for the table and the indexes. The first index is a covering index which is what I was testing to determine if it slowed down the...

No it is just a insert statement with hard coded values for the insert.

Thanks Grant, I'm working on it. I'll post what I find out.

Thanks Grant. I have some additional info though. On each of the servers we have a reference database that is identical on all servers. This databae has very little data...

Thanks Matt. Coincidentally I just downloaded the same doc from a different thread. Looks to be an essential read. I just switched from being a developer to DBA about 6...

matt stockham (4/22/2009)

Whatever it is that's making these view updates take so much longer on prod2 and prod3 is possibly affecting all queries issued from these servers, which is why...

I found the URL to your blog in your profile. I'll look for your post.

Thanks,

Steve

I think I am going to try and diagram the binding process for these views for the developers so they can see how expensive the mask is for the application's...

Yes, we have nested views alright! Way more than I am accustomed to. In two of the sub queries there is a view VStudents which is based on a view...