Find Most executed queries

SELECT TOP 50
QueryState.execution_count
,OBJECT_NAME(objectid)
,query_text = SUBSTRING(
qt.text,
QueryState.statement_start_offset/2,
(CASE WHEN QueryState.statement_end_offset = -1
THEN len(convert(nvarchar(max), qt.text)) * 2
ELSE QueryState.statement_end_offset
END - QueryState.statement_start_offset)/2)
,qt.dbid
,dbname = db_name(qt.dbid)
,qt.objectid
FROM sys.dm_exec_query_stats QueryState
CROSS APPLY sys.dm_exec_sql_text(QueryState.sql_handle) as qt
ORDER BY...

Get all queries running against any specific table

/*Get list of all queries hitting any specific tables*/SELECT DISTINCT TOP 100ProcedureName = OBJECT_SCHEMA_NAME(sqlTxt.objectid) + '.' + OBJECT_NAME(sqlTxt.objectid),SQLStatement = SUBSTRING(sqlTxt.Text,(QueryState.statement_start_offset/2)+1,CASE QueryState.statement_end_offsetWHEN -1 THEN DATALENGTH(sqlTxt.text)ELSE QueryState.statement_end_offsetEND...

Missing index with create statements

Missing index :- Scripts will help you to get all the missing index and prepare script for new index.

/*
Description:- This Query...

How we can determine table column dependencies within a SQL database?

I came a situation during some analysis where i had to figure out all dependency of a column across database....

Column and table constraints

Column and Table Constraints
Constraints can be column constraints or table constraints.A column constraint is specified as part of a column...

What is Constraints in TSQL?

Constraints let you define the way the Database Engine automatically enforces the integrity of a database. Constraints define rules regarding the...

What is – DML, DDL, DCL and TCL in TSQL?

In transact SQL , different type of activity performed ,like we can create database , manipulate date , update, delete even control access...

Combining statement with conditional operators

Operators “AND”, “OR”Sometime we need to combine two or more TSQL statement based on some conditions, that we can achieve...

Aggregate Functions

Aggregate Functions
MINReturns the smallest value in a given columnMAXReturns the largest value in a given columnSUMReturns the sum of the...

TSQLCircleLive: What will be the result of the query below? Explai...

TSQLCircleLive: What will be the result of the query below? Explai...: select case when null = null then 'True' else 'False'...