Arun Kumar

Arun Kumar has over 8 years' extensive working experience in database query development, design, supporting many different versions of MS-SQL. He has worked to develop efficient reports, index optimization for complex queries, and has finance and operation domain experience. He has also worked with SPLUNK and enjoys training technical and non-technical colleagues.
  • Interests: Database developer and designing

All authors

Blog Post

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...

2018-09-18

1,988 reads

Blog Post

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...

2018-09-18

3,574 reads

All authors

Blogs

Build a Serverless Todo App With AWS, Pulumi, and Python

By

Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible...

Master SQL Subqueries with This Free Course

By

Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...

Removing the REST Endpoint in the Data API Builder

By

The more I work with the Data API Builder (DAB), the more I lean...

Read the latest Blogs

Forums

Vector DB implementation using FAISS

By utsav

Comments posted to this topic are about the item Vector DB implementation using FAISS

The Types of Changes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Types of Changes

Escaping Like I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Escaping Like I

Visit the forum

Question of the Day

Escaping Like I

I have this data in a SQL Server 2022 table: 

PlayerIDPlayerNamePlayerStatus
1The \%ChampActive
2The ChampActive
3The_ChampionActive
4The__ChampionActive
5The\_ChampActive
How many rows are returned by this code in SQL Server 2022? 
select PlayerName from player
where playername like 'The\_C%' escape '\'
 

See possible answers