Large tables is relative. How do you define "large table"?
Like Allen, I would be interested in knowing what blocking issues have been observed. And I would also be interested in the statements those analysts want to use. Will this be stored procedures? Do they *really* need the most recent data or might they be able to do their analysis with previous day's data? Hm, coming to think of it, there are a lot of questions to be answered before even thinking about how to technically solve them.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]