Home Forums SQL Server 7,2000 T-SQL Need Guidelines For Using SELECT INTO RE: Need Guidelines For Using SELECT INTO

  • 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]