Does SQL server automatically purge these out after a given length of inactivity or do I need to worry about purging them automatically? If so, how do I query for a list of tables to purge?
...
Basically i want to be able to dynamically create a temp table based off of an existing table, and then insert values into the temp table, and select the inserted values.
i've got the part where i can create the temp table working just fine, it's just that inserting and selecting form it aren't working too well.
here's my current code....
How can i Load Temptable on Server B by reading data from Server A in Dataflow task.
...
I have a function...in which I have return type as table variable...
But performance will be increased if we use temp tables..as we have more data.
...