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
SQL SERVER – Maximum Allowable Length of Characters for Temp Objects is 116 – Guest Post by Balmukund Lakhani
Balmukund Lakhani (B | T | S) is currently working as Technical Lead in SQL Support team with Microsoft India GTSC. In past 7+ years with Microsoft he was also a part of the Premier Field Engineering Team for 18 months. During that time he was a part of rapid on-site support (ROSS) team. Prior to joining Microsoft in 2005, he worked as SQL developer, SQL DBA and also got a chance to wear his other hat as an ERP Consultant. Let us learn about Maximum Allowable Length of Characters for Temp Objects is 116.
SQL SERVER – How to Drop Temp Table – Check Existence of Temp Table
I have received following questions numerous times: “How to check existence of Temp Table in SQL Server Database?” “How to drop Temp Table from TempDB?” “When I try to drop Temp Table I get following error. Msg 2714, Level 16, State 6, Line 4 There is already an object named…
Read More