Hi dears, so for we have seen about the incremental update statistics and index enhancement on our previous blog post.
Now we will see about, how SQL server 2014 can cache temp tables. Before we move further into the subject, will see about temp tables in crisp. These are the tables created at the run time and these tables are created within the “tempdb” database. To identify a table as a Temporary Table within the SQL statement, prefix the table name with the “#” character. And also we should know one more fact the caching is not per procedure , the caching is per objects.
SQL Server 2014 has given us some room, by which if we make our temp table in a proper way the temp table can be cached. We will see how this is possible.
