Azure Data Platform · Azure Services · Data Engineering · Did you Know! · Q & A · Real Scenario Logic's

Question and Answer #5

Question – Out of below 2 servers, We need to find which one is 'Microsoft Azure Synapse Analytics'? Other might be 'SQL Database'.1️⃣ "s1.database.windows.net"2️⃣ "s2.database.windows.net" How to find? 💡 For "Dedicated SQL pool (formerly SQL DW)" , the endpoint would be same as SQL Database ".database.windows.net" [Still pricing tier is different: cDWU vs DTU/vCore]Under "Azure Synapse Workspace"… Continue reading Question and Answer #5

Advertisement
Basic Logics · Real Scenario Logic's

Clone Temporary Table Structure to New Physical Table in SQL Server

Introduction In this Article, we will see how to Clone Temporary Table Structure to New Physical Table in SQL Server.This is applicable for both Azure SQL db and on-premises. Demo SQL Script IF OBJECT_ID('TempDB..#TempTable') IS NOT NULL DROP TABLE #TempTable; SELECT 1 AS ID,'Arul' AS Names INTO #TempTable; SELECT * FROM #TempTable; METHOD 1 -… Continue reading Clone Temporary Table Structure to New Physical Table in SQL Server