SQL Server Performance

Cannot create a row of size 11326 which is greater than the allowable maximum row size of 8060

Discussion in 'SQL Server 2008 General DBA Questions' started by WingSzeto, Nov 9, 2011.

  1. WingSzeto Member

    I have the following SQl statement which join with a few #tables. I need to have all the columns from each #table. Unfortunately it consists of about 800 columns. When I execute the Select statement, I encounted the error, Cannot create a row of size 11326 which is greater than the allowable maximum row size of 8060.Some temp tables has couple varchar(max) fields and some may have 5 or 6. Does anyone know how to make the Select statement run successfully.

    W
  2. WingSzeto Member

    Sorry forget to post the sql statement.

    Select * from #EmployeeInfo EI
    left join #EmployeeTitle ET on EI.title = ET.title
    left join #SpecialSkill ss on EI.Empl_ID = ss.Empl_ID
    left join #workHist wh on EI.empl_id = wh.empl_Id
    left join #Education ed on EI.empl_id = ed.empl_Id
    order by EI.lastname, EI.firstname, EI.empl_ID
  3. FrankKalis Moderator

    I'm not sure that this is the root cause for this error. What do the temp tables look like?
  4. Shehap MVP, MCTS, MCITP SQL Server

    I think you work under SQL Server 2000 or DB compatibility Level 80 at least where you could find such limitation issues...

    Hence, please try to change it to DB compatibility Level 90 or 100 and let me know the output
  5. johnson_ef Member

Share This Page