when to choose temp table or in memory tables for SSRS reports

When you are developing SSRS reports, we don't pay attention while choosing temp table or in memory


when we know that we have less data in report we can choose in memory table

when we are aware that there are lot of datas choose temp table instead in memory tables.

  In a developer's point of view, temporary tables store data in the same way as normal physical tables, except that the data is automatically dropped when no longer required.

     Prior to Dynamics AX 2012 versions, only one type of temporary table was available. In AX 2012, however, the Temporary property on tables was replaced with a new property: TableType, which has three possible values:

·         Regular - a standard physical table

·         InMemory - the type of temporary table which existed in the previous versions of Dynamics Ax. Such tables are held in memory and written to a local disk file once they grow beyond a certain point

·         TempDB - a new option in Ax 2012. They are "physical" temporary tables held in the SQL Server database.