Thanks Grant I'll check those whitepapers ( Grant is somewhat rare, but it's my son's name also ) It does appear that qualifying the ownership...

I'll have to dig for solid evidence on...

colin Leversuch-Roberts (2/21/2008)

---

I don't want to sound contrite but if you don't have experience of the platform you should be very very careful about posting , especially under performance tuning...

"no tables qualified by dbo. you're inviting a system-overhead in order to resolve the schema."

Is this still the case in sql 2005?

A little googling indicates 1) whether set rowcount or top performs better is unclear without testing 2) set rowcount is deprecated

I should be able to get an execution plan. I tried to edit the post to reformat the Tsql but never saw a "post" just preview/edit/spell check. ...

I see your point about having business logic scattered about. We are just now talking about a "data warehouse" for

reporting -- possibly via a second log shipping arrangement....

This topic must be a little on the theoretical side for database folks busy trying to survive day to day. I thought this forum would be less about technical...

Yes, I'm not happy with the all in one database approach. I'm told the new application either requires or assumes this. It may turn out that performance, if...

We will need to build a separate system for reporting ( data warehouse ). The application limits recordsets returned to the browser to 2000 records. One immediate hurdle...

Take a look at sp_spaceused It will show how much actual space tables and indexes occupy. Even if your mdf data file is 100GB on disk,...

SAS70 has different levels of audit. This year ours was ramped up a bit and they did ask me who the sysadmins were ( at the instant anyway...

My point about SAS70 is that your customers want to know their data is safe with you and that you aren't adding people to roles like sysadmin without great care....

I think the main point is that those who are developing, in a development environment ( where accidents aren't that big a deal ) should not be moved into a...

Thanks Ben, I'll check out the SDK.  I did see those filtered views in our database.  Obviously with a database this complicated, doing a select * on every table and...