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 MoreSQL SERVER – SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable – Part 2
Some questions never get old. One of them is temp table variable and temp table in SQL Server. I have previously wrote about this indepth here : SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable Recently I received question: Can temporary table have indexes? If yes, are…
Read More