Posted inPerformance Tuning TSQL
Should we check [context_switches] for SQL Server Query from Performance Point
Hi Friends. If you are wondering if we should check [context_switches] counter for SQL Server…
![Should we check [context_switches] for SQL Server Query from Performance Point](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2018/05/Context-Switches.png?fit=1024%2C252&ssl=1)
Posted inTSQL
Starting SQL Server Database Administration Classes from May 2018
Hi Friends, I have finally decided to go with another batch for SQL Server Database…
Posted inHealth Check TSQL
SQL Server – Stop Agent Job After Threshold Time and Log the Query Metrics
Being a DBA, I know the pain of a long running job creating performance issues…
Posted inTSQL
SQL Server – Get Database Backup History for Crash Recovery
It is not easy to find out right backups for restore activity when people are…
Error/Fix: Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation
Recently I was working on a SQL query in my inventory database, and was greeted…
Posted inTSQL
Script-SQLDatabaseRestore cmdlet in SQLDBATools Module
Restoring multiple databases can be painful especially when each of them have multiple database file(s).…
Posted inExecution Plan Health Check Performance Tuning TSQL
What’s Running – Find All Details of Running Queries
I often see DBAs/developer struggling to find what's wrong with query. The first step in…
![[usp_AnalyzeSpaceCapacity] – SQL Server Space Management Made Easy](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2018/03/%40getVolumeSpaceConsumers_TableResult.jpeg?fit=1024%2C661&ssl=1)
Posted inTSQL
[usp_AnalyzeSpaceCapacity] – SQL Server Space Management Made Easy
DBAs! We all know the pain of creating new data or log files at new…
Posted inPerformance Tuning TSQL
Common Myth: Loop is Always Faster than Cursor
From past few weeks, I have been taking interview for Sr. SQL DBA position in…
Posted inPerformance Tuning Powershell TSQL
Deploy SQL-Server-First-Responder-Kit with Powershell
There are many tools in market that can help you troubleshoot in specific situations. My…