Azure Data Platform · Azure Services · Data Engineering · Performance tune

T-SQL Queries Vs Spark SQL Queries

Introduction In this blog post, we will see some of the Transact SQL (T-SQL) Queries and its equivalents in Spark SQL with examples. some T-SQL vs Spark SQL Keyword Differences T-SQL Queries The below input as well as output taken by running T-SQL Queries in SSMS via Azure Synapse Analytics/Dedicated SQL Pool, the same we… Continue reading T-SQL Queries Vs Spark SQL Queries

Advertisement
Basic Logics · Did you Know! · Performance tune · Query Performance · Real Scenario Logic's

Unique Filtered Index in SQL Server

Introduction In this blog post, we will see what is Unique Filtered Index and how to create it and what are the challenges while creating it and what are the advantages of using it in SQL Server. Unique Filtered Index - What it is? As we all know, the UNIQUE Index will allow only Unique values.… Continue reading Unique Filtered Index in SQL Server

Dynamic Management View · Performance tune · Query Performance · Real Scenario Logic's

Top 20 Poor Performing Queries in SQL Server

Introduction In this Blog post, we are going to see How to find the Top 20 Worst Performing Queries in SQL Server. We can use the below query as Query Performance Insight/Monitor that is common for both On-premises SQL Database and Azure SQL Database. SQL Script SELECT TOP 20 ObjectName = OBJECT_SCHEMA_NAME(qt.objectid,DBID) + '.' +… Continue reading Top 20 Poor Performing Queries in SQL Server