The real question would be ; How many users do you have on the db and what are they doing on it??

You should always normalize.

You should denormalize only when you have no other choice (for performance) and if the data is for reports only (less overhead of keeping 2-3 tables in...

Actually it means that the server will read ALL data, committed or not (read even if the commit transaction hasn't been issued).

So I would doubt that this is the problem...

check out sp_addlinkedserver in BOLS.

exec dbname.dbo.spname

Can we see some sample data?

Check the calling applications to make sure they are not calling using "with recompile".

Also make sure that all the calls made are using the same format >>

With and without the...

Just merge those columns in the main design.. then it'll be much easier.

Are all those columns datetimes (as in not varchars or ints)??

That would be one other major flaw I'd want to avoid .

Check my latest version, it'll perfom faster than the first one I did. Make sure understand the where clause in the final select... it's the validation part and it...

Isn't there any tables that have inserts in them???

Maybe the db was just set to a huge size and didn't need to grow, but now that the db is "full",...

First of all you are right; My solution didn't provide exactly what was needed (actually was shipping out too much). This opens the door for a real set based...

If only that were true .

I wouldn't be mysefl without my usual typeaus .

23 spellings????????????????

can we see a list .