What is more optimal for the data load – Temp Table or Regular table? Why? The question was very simple but interesting one and I have decided to answer.
SQL SERVER – Dynamic SQL and Temporary Tables
Earlier on this blog I received following follow up question about Dynamic SQL and Temporary Tables. Let us understand a bit more in detail.
SQL SERVER – Dynamic SQL and Global Temporary Tables
During the recent work of Comprehensive Database Performance Health Check, we had a very interesting situation of Dynamic SQL and Global Temporary Tables.
SQL SERVER – DROP Multiple Temp Tables Using Cursors on Azure
SQL Server Expert Ahliana Byrd has written a very interesting script to DROP Multiple Temp Tables Using Cursors on Azure, which we have included today.
How Many Temporary Tables are Created So Far in SQL Server? – Interview Question of the Week #149
Question: How Many Temporary Tables are Created So Far in SQL Server?
SQL SERVER – How to Create A Global Temporary Table?
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.