sql-server Archives - Page 7 of 8 - Performance Tuning And Infra Automation

A Curious Case of Orphan User

Hi Friends, Today at work I received an access request to provide multiple database permissions to multiple AD groups on servers. After providing appropriate db roles membership to requested AD…

Ajay Dwivedi November 30, 2016

TSQL

How do I verify if my login if set to Non-Expiry [SQL Server]?

Today I was working on multiple access/permission requests of same user on multiple servers. Due to previous poor experience using sql authenticated login set to expiry by DBA, he kept…

Ajay Dwivedi November 28, 2016

Execution Plan Performance Tuning TSQL

Query Optimization 03 – Users statistics (individual user) [StackOverflow]

Hi Friends, this is my 3rd blog post of series Query Optimization. In last blog post Questions and Answers per Month, we took optimization decision by analyzing warnings suggested by…

Ajay Dwivedi November 27, 2016

Database Administration Errors

Error/Fix: The Extended Events session named “blocked_process” could not be found.

Two days back while I am presenting in a KT session within team on how to use Extended Events for trapping blocking and deadlocks, and use the SQL Sentry Plan…

Ajay Dwivedi November 24, 2016

Execution Plan Performance Tuning

Query Optimization 02 – Questions and Answers per Month [StackOverflow]

Hi Friends, this is my 2nd blog post of series Query Optimization. In 1st blog post What is my accepted answer percentage rate, we took optimization decision based on Logical…

Ajay Dwivedi November 21, 2016

TSQL

Script to Analyze Mount Point Space & Generate Shrink File Statements

In my organization, we often receive far too many incidents for low free disk space. As part of resolution we have to check for unexpected files/folders on the mount point…

Ajay Dwivedi November 20, 2016

Execution Plan Performance Tuning

Query Optimization 01 – What is my accepted answer percentage rate [StackOverflow]

I am very often asked on how to start query tuning which gave me an idea to start a Query Tuning blog series. I shall be taking random and slow…

Ajay Dwivedi November 14, 2016

Execution Plan Performance Tuning

Why my query is slow?

I often receive questions by developers and DBAs on how to find what's the issue with their query or why it is so slow. This was a similar case. One…

Ajay Dwivedi November 12, 2016

Database Administration Errors

SQL SERVER – Fix : Error : The request failed or the service did not respond in a timely fashion

Yesterday, I was working on my office laptop with SQL Server which was installed previous day only, when all of a sudden I received message of machine getting restart due…

Ajay Dwivedi November 3, 2016

Errors Internals Performance Tuning

Performance Tuning With Predicate Logic

I have often seen Developers write predicate logic without bothering about performance. That works most of the time. But what about queries that return huge data sets? Is there any…

Ajay Dwivedi October 15, 2016