Posted inExecution Plan Performance Tuning TSQL
Question/Answer – Should I filter the data in Sub Queries??
Recently a good friend of mine asked me question whether is there any performance benefit…
![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 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…
Posted inPowershell
Copy SQL and Batch Files from Source to Destination using PowerShell
Recently as part of Server Migration, I had to move nested folders and files from…
Posted inDatabase Administration
OlaHallengren Maintenance Solution – DatabaseBackup – Configurable Backup Directory folder names
If you are a DBA then you understand the importance of having robust Database Maintenance…
Posted inPowershell
Get-ProcessForDBA cmdlet in SQLDBATools Module
Troubleshooting high memory utilization on servers involves finding out processes which are consuming RAM. But…
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).…
