tsql Archives - Page 2 of 4 - Performance Tuning And Infra Automation

OlaHallengren Maintenance Solution – DatabaseBackup – Configurable Backup Directory folder names

If you are a DBA then you understand the importance of having robust Database Maintenance Solution. Like everybody in SQL Server Community, Ola Hallengren's Maintenance Solution is my favorite. Two…

Ajay Dwivedi April 24, 2018

Health 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 for other jobs and user sessions. For my current organization, I have created below TSQL…

Ajay Dwivedi April 19, 2018

TSQL

SQL Server – Get Database Backup History for Crash Recovery

It is not easy to find out right backups for restore activity when people are watching you during database crash situation. So I have created below TSQL script that would…

Ajay Dwivedi April 18, 2018

Errors TSQL

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 with below error message:- Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the…

Ajay Dwivedi April 15, 2018

TSQL

Script-SQLDatabaseRestore cmdlet in SQLDBATools Module

Restoring multiple databases can be painful especially when each of them have multiple database file(s). Four years back, I wrote TSQL script that would accept database backup path, and result…

Ajay Dwivedi April 14, 2018

Execution Plan Health Check

[sp_HealthCheck] – Get SQL Server Health Details

Hi Friends, Ever wanted to check the heartbeat of SQL Server. It is a very common activity for a SQL Server user to check CPU, SQL Memory Utilization, Available Memory…

Ajay Dwivedi March 31, 2018

Execution Plan Health Check Performance Tuning

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 troubleshooting queries is finding out information like batch text, query text, batch execution plan, individual…

Ajay Dwivedi March 30, 2018

Performance 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 my team. What I found is, even candidates saying that they have expertise in Performance…

Ajay Dwivedi July 22, 2017

Performance 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 personal favorite for finding out issue with SQL Server is SQL-Server-First-Responder-Kit created by Brent Ozar…

Ajay Dwivedi July 19, 2017

Internals Performance Tuning TSQL

Non – Trusted Foreign Keys in SQL Server

Today, I was working with one user to troubleshoot their query timeout issues. Analyzing wait stats on server, I found 'LCK_M_X' wait to be most prominent wait on server. This…

Ajay Dwivedi July 17, 2017