How to write performance queries! Take advantage of the Temporary Table Caching
Hi Guys, I don’t usually talk about numbers but I have to say that almost 8000 clicks in just one month on my blog is really a huge amount! So, thanks to the 7000 k friends who follow me! In the last post (click here) we saw in detail how the tempDB database works. Today we see how to use what we learned to write in temporary tables as quickly as possible. In this way you can put your hand to your procedures to make them run ...and for free! Let’s see how to exploit the temporary table cache mechanism! Enjoy! Temporary Table Caching In the previous post we saw that there are some rules to take advantage of the temporary table caching . We said that in the following cases table are not cached : Named constraints are not created DDL statements that affect the table are not run after the temporary table has been created. for example the CREATE INDEX or CREATE STATISTICS statements Temp table is not created by using dynamic SQL Temp table is created inside another object,...