Skip to content
Performance Tuning And Infra Automation

I love performance tuning and building automation

  • Home
  • About Me
  • SQL Resources
  • Privacy Policy
  • Contact Me
  • Home
  • About Me
  • SQL Resources
  • Privacy Policy
  • Contact Me
  • facebook.com
  • twitter.com
  • t.me
  • instagram.com
  • youtube.com
Subscribe
  • Home
  • sql-server
  • Page 7
A Curious Case of Orphan User
Posted inDatabase Administration

A Curious Case of Orphan User

Posted by By Ajay Dwivedi November 30, 2016
Hi Friends, Today at work I received an access request to provide multiple database permissions…
Read More
How do I verify if my login if set to Non-Expiry [SQL Server]?
Posted inTSQL

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

Posted by By Ajay Dwivedi November 28, 2016
Today I was working on multiple access/permission requests of same user on multiple servers. Due…
Read More
Query Optimization 03 – Users statistics (individual user) [StackOverflow]
Posted inExecution Plan Performance Tuning TSQL

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

Posted by By Ajay Dwivedi November 27, 2016
Hi Friends, this is my 3rd blog post of series Query Optimization. In last blog…
Read More
Error/Fix: The Extended Events session named “blocked_process” could not be found.
Posted inDatabase Administration Errors

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

Posted by By Ajay Dwivedi November 24, 2016
Two days back while I am presenting in a KT session within team on how…
Read More
Query Optimization 02 – Questions and Answers per Month [StackOverflow]
Posted inExecution Plan Performance Tuning

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

Posted by By Ajay Dwivedi November 21, 2016
Hi Friends, this is my 2nd blog post of series Query Optimization. In 1st blog…
Read More
Script to Analyze Mount Point Space & Generate Shrink File Statements
Posted inTSQL

Script to Analyze Mount Point Space & Generate Shrink File Statements

Posted by By Ajay Dwivedi November 20, 2016
In my organization, we often receive far too many incidents for low free disk space.…
Read More
Query Optimization 01 – What is my accepted answer percentage rate [StackOverflow]
Posted inExecution Plan Performance Tuning

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

Posted by By Ajay Dwivedi November 14, 2016
I am very often asked on how to start query tuning which gave me an…
Read More
Why my query is slow?
Posted inExecution Plan Performance Tuning

Why my query is slow?

Posted by By Ajay Dwivedi November 12, 2016
I often receive questions by developers and DBAs on how to find what's the issue…
Read More
SQL SERVER – Fix : Error : The request failed or the service did not respond in a timely fashion
Posted inDatabase Administration Errors

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

Posted by By Ajay Dwivedi November 3, 2016
Yesterday, I was working on my office laptop with SQL Server which was installed previous…
Read More
Performance Tuning With Predicate Logic
Posted inErrors Internals Performance Tuning TSQL

Performance Tuning With Predicate Logic

Posted by By Ajay Dwivedi October 15, 2016
I have often seen Developers write predicate logic without bothering about performance. That works most…
Read More

Posts pagination

Previous page 1 … 5 6 7 8 Next page
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 99 other subscribers
See what other community members think about SQLMonitor.
Recent Posts
  • Get StackOverflow2013 Database for PostgreSQL & SQLServer
  • Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
  • LogRotate Policy For PostgreSQL
  • Run Ansible Playbooks with Github Action
  • SQLServer Gradually Becomes Slow Until Reboot
Facebook With Ajay Dwivedi
Facebook With Ajay Dwivedi

CATEGORIES

  • Ansible 1
  • Baseline-SQL-Server 22
  • Database Administration 11
  • DevOps 1
  • Errors 15
  • Execution Plan 8
  • Growth & Development 2
  • Health Check 8
  • Internals 3
  • Linux 4
  • Performance Tuning 35
  • PostgreSQL 3
  • Powershell 8
  • SQL Alerts 5
  • SQLMonitor 17
  • TSQL 41
Copyright 2025 — Performance Tuning And Infra Automation. All rights reserved. Bloglo WordPress Theme
Scroll to Top