Yash Shah, Author at Technology Cue – IT Consulting & Digital Transformation in Brisbane

ETL SQL Queries

To check – How long has your SQL Server has been running since the last SQL Server startup?

To get the information about how long has your server been running since the last SQL Server startup? SELECT @@Servername AS ServerName , create_date…

Yash Shah31/07/2023

SQL Queries SQL Tips

To check – How long has your SQL Server has been running since the last SQL Server startup?

To get the information about how long has your server been running since the last SQL Server startup? Code: SELECT @@Servername AS ServerName ,…

Yash Shah09/02/2023

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

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

Datawarehouse ETL SQL Queries SQL Tips

How to create Columnstore Index using SQL

Problem Statement:-

Yash Shah24/11/2022

Python

Download YouTube Videos in Python

#1 Install and import PyTube library to download the video: pip install pytube import pytube   #2 Ask for the video URL: url =…

Yash Shah05/09/2022

Yash Shah

To check – How long has your SQL Server has been running since the last SQL Server startup?

To check – How long has your SQL Server has been running since the last SQL Server startup?

How to deal with Long running SQL Query?

How to create a Running Total Function in SQL

How to create a Volume Data for Database

How to create Columnstore Index using SQL

Download YouTube Videos in Python

Services

Get in touch

Subscribe Now