Datawarehouse

Understanding and Resolving Stale Datasets Data Engineer Data Governance Datawarehouse ETL

Understanding and Resolving Stale Datasets

Stale Datasets in Data Management One of the common issue that organizations often face is dealing with stale datasets. A stale dataset refers to data…

Mihir Shah12/07/2024

How to deal with Long running SQL Query? Datawarehouse ETL SQL Queries SQL Tips

How to deal with Long running SQL Query?

Problem Statement: Long running queries have been found in the plan cache. These may be ETL, reports, or other queries that should run long. Or…

Yash Shah07/12/2022

How to create a Running Total Function in SQL Datawarehouse ETL SQL Queries SQL Tips

How to create a Running Total Function in SQL

Problem Statement: In SQL, a running total is the cumulative sum of the previous numbers in a column. Code Snippet: -- Create a view that…

Yash Shah28/11/2022

Datawarehouse ETL SQL Queries

How to create a Volume Data for Database

Problem Statement: This article describes how to display the data and log space information for a database in SQL Server by using SQL Server Management…

Yash Shah24/11/2022

How to create Columnstore Index using SQL Datawarehouse ETL SQL Queries SQL Tips

How to create Columnstore Index using SQL

Problem Statement:-

Yash Shah24/11/2022

At Technology Cue, we help organisations build a data-driven culture, to gain and sustain competitive advantage in today’s market. We consult, design and deliver innovative data analytics solutions using state-of-the-art Microsoft Cloud technologies.