Duplicated Text

• Question

• 

  

  0

  Sign in to vote

  Course 4328: Grouping and Sumarizing Data in Microsoft SQL Server 2005

  Section: Summarizing Grouped Data
  https://www.microsoftelearning.com/courseAccess/coursePlayer.aspx?courseId=59942&topicId=215940

  Limitations of the GROUP BY clause:  

  • SQL Server uses temporary structures to build aggregates for the GROUP BY clause. It stores these temporary structures in a tempdb database. Because this intermediate worktable is needed to hold intermediate query results, each GROUP BY clause is limited to 8,060 bytes.

  • SQL Server uses temporary structures to build aggregates for the GROUP BY clause. It stores these temporary structures in a tempdb database. Because this intermediate worktable is needed to hold intermediate query results, each GROUP BY clause is limited to 8,060 bytes.

  • The columns in a GROUP BY clause are limited to the number of bytes per GROUP BY clause.

  Same text listed twice.

  Friday, June 18, 2010 6:54 PM