Two days ago, I wrote an article SQL SERVER – How to Create Table Variable and Temporary Table? It was a very basic article for beginners. However, to my surprise, I have got tremendous response to that blog post and also got quite a lot of feedback about the it. Out of all these one feedback which stood out was that I did not include discussion about Global Temporary Table. I agree that when I was writing this blog post I did not think of this, but it is never too late to write about any topic. Let us see in this blog post how to create a global temporary table?
SQL SERVER – How to Create Table Variable and Temporary Table?
This is a very simple question and indeed many of us know about this one. However, if you are absolutely beginner, you will for sure need help with this one. Let us understand how we can create a table variable and temporary table in this simple tutorial.
How to Create Temp Table From Stored Procedure? – Interview Question of the Week #140
Question: How to Create Temp Table From Stored Procedure?
How is Oracle Temporary Table Different from SQL Server? – Interview Question of the Week #133
Question: How is Oracle Temporary Table Different from SQL Server?
SQL SERVER – Interesting Observation – Count of Temporary Table Re-generations
The best part of my SQL Server Performance Tuning Practical Workshop is that at the end of the workshop we spend quite a good amount of time to solve the issues users have in their production system. During one of the recent workshop, I was asked a very interesting question about temporary tables.
How to Insert Results of Stored Procedure into a Temporary Table? – Interview Question of the Week #124
Question: How to Insert Results of Stored Procedure into a Temporary Table?
SQL SERVER – Inside Temp table Object Creation – Part II
After my previous article on “Inside Temp table object creation”, I had a number of people ask me more about this topic. There seems to be a need for understanding these basic fundamentals that we have known for ages in a refreshingly new way. Though there were tons of mails…
Read More