SELECT SUM (qrs.count_executions) *   AVG (qrs.avg_logical_io_reads) as  est_logical_reads, SUM (qrs.count_executions) AS...

--Query to find missing index from query store, from last 30days usage SELECT TOP 20 qsq.query_id, SUM(qrs.count_executions) *...

--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...

--SQL Server Database log full due to replication, you can run the following command to mark all ---the replication transaction is done,...

--disable cdc master --Table Contains list of all the tables where cdc needs to be disabled - [dba].dbo.replication_cdc_table --execute...

select schema_name(tab.schema_id) as [schema_name], pk.[name] as pk_name, substring(column_names, 1, len(column_names)-1) as [columns],...

select distinct count(query_id) as total_query --,QUERY_TEXT --,DATABASE_NAME --,SCHEMA_NAME --,QUERY_TYPE --,USER_NAME --,ROLE_NAME...

select GRANTEE_NAME AS "USERNAME", ROLE from SNOWFLAKE.ACCOUNT_USAGE.GRANTS_TO_USERS where DELETED_ON is null and Role = 'ROLENAME' and...

select Total_Elapsed_Time/60000 Total_Time_MINS, Database_name, schema_name, User_name, Role_name, Warehouse_name, Warehouse_size,...

--clone table in snowflake create table orders_clone clone orders;

--get task history: select * from table(information_schema.task_history( scheduled_time_range_start=>dateadd('hour',-1,current_timestamp(...

SET ANSI_NULLS ON; SET ARITHABORT ON; SET QUOTED_IDENTIFIER ON; SET NOCOUNT ON; Declare @SEQUENCE_SCHEMA varchar(max); Declare...

The Query Store provides database administrators with in-depth insights on query plans and performance metrics. By default, execution...

Understanding the SQL Server Proportional fill algorithm When creating a database, SQL Server maps this database with minimum two...

connecting to RDS instance SQL Server

Script to clone tables in snowflake Run this script in sql server to generated the output command: snowflake table clone script. SET...

--Execute the following script against the User Database where you need to find DB User permission. DECLARE @sql VARCHAR(2048) ,@sort INT...

--Script to verify snapshot isolation enabled SELECT name , s.snapshot_isolation_state , snapshot_isolation_state_desc ,...

Below is the script to enable change data capture to customer table. USE DB_name GO -- Enable CDC on the database. if ( not exists (...

Find list of all the partitioned tables in sql server. use userdb_name go select distinct t.name from sys.partitions p inner join...