query-performance – CodeRavo

Monitoring and Managing Active Queries in SQL Server

Introduction Managing database performance is a critical task for any database administrator. In Microsoft SQL Server, … Monitoring and Managing Active Queries in SQL ServerRead more

active-queries, activity-monitor, dmvs, kill-command, query-performance, sp-who2, SQL Server, sql-server-management-studio, sys-dm-exec-requests

Understanding SQL Server Query Performance: LIKE vs. CONTAINS

When working with large datasets in SQL Server, performance is a critical consideration when writing queries. … Understanding SQL Server Query Performance: LIKE vs. CONTAINSRead more

Contains, Full-Text Search, indexing, like, query-performance, SQL Server, wildcard-searches