Home Forums SQL Server 2008 T-SQL (SS2K8) INSERT/SELECT from xml.nodes very slow RE: INSERT/SELECT from xml.nodes very slow

  • May 12, 2014 at 9:21 am

    #1712723

    Bill Talada (5/12/2014)

    Q.E.D.

    I added this weird line after the FROM clause and now results are immediate!

    OPTION ( OPTIMIZE FOR ( @xml = NULL ) )

    Good stuff!

    I had forgotten about this, if I remember correctly, it is an 2008 sp1 issue.

    😎