Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Maximum number of CROSS APPLY functions RE: Maximum number of CROSS APPLY functions

  • September 30, 2016 at 2:19 pm

    #1904259

    I was curious about this too and did a little research. There appears to be absolutely nothing about this out there about APPLY. Since APPLY is very similar to a JOIN (joins and APPLY are both table operators with respect to logical query processing) so I looked up the maximum number of joins.

    In SQL Server 2005 and earlier the number of JOINs was limited to 256 tables[/url]. In 2008+ it's limited to the "Limited only by available resources" (Note where it reads, "Tables per SELECT statement").

    I know this does not answer your question but it's all I could find. I'm going to play around with some dynamic SQL and see if I can find a limit.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001