SQL Server Performance

A table or view, A table or view using fast-load ?

Discussion in 'SQL Server 2005 Integration Services' started by linus516, Jul 19, 2007.

  1. linus516 New Member

    What is the different between

    -A table or view.
    -A table or view using fast-load options.

    for OLE DB destination

  2. satya Moderator

    Books online for SQL Server is the best option for you to look at such information, as far as FASTLOAD option using table or view has no difference.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    @http://www.askasqlguru.com/

    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. dineshasanka Moderator

    if it is fast load, you can't enable error configuration for row dirrect which is a major disadvantage. Othe than that it is much fater than the other one

Share This Page