— Missing Index Script — Original Author: Pinal Dave SELECT TOP 50 dm_mid.database_id AS DatabaseID, dm_migs.avg_user_impact*(dm_migs.user_seeks+dm_migs.user_scans) Avg_Estimated_Impact, dm_migs.last_user_seek
Continue readingWhat is Dedicated Admin Connection (DAC)? How to Establish Dedicated Administrator Connection(DAC) in SQL Server ?
Dedicated Admin Connection (DAC):- DAC allows database administrators to perform T-SQL commands to connect to SQL Server instances and to
Continue readingHow can non-sysadmin user change their own password in SQL Server?
Last time one of my friend asked me to how can i change the own password in SQL Server? Why
Continue readingHow to find out the SQL Server Properties?
You can execute below query to get SQL Server Properties:- create table #server(ID int, Name sysname null, Internal_Value int null,
Continue readingHow to check the database Properties in SQL Server?
You can execute the below query to get the database property information:- select sysDB.database_id, sysDB.Name as ‘Database Name’, syslogin.Name as
Continue readingHow to find that when was the last time SA account property or password changed ?
We can find out last modification date of SA account through below query:- USE Master GO SELECT [name], sid, create_date,
Continue readingWhy SQL Server service is not starting?what are common reasons for failures?
These are common reasons for failures:- SQL Service account password has been changed but not updated at SQL Server Services
Continue readingHow to Find and Fix Orphaned Users in SQL Server
After the migration of SQL Server databases we have to find the orphan users In SQL Server & need to
Continue readingHow to make faster DBCC check db execution process?
Below query enforces an exclusive lock on database, which increase the execution faster of DBCC command:- DBCC CHECKDB (‘Prod1DB’) WITH
Continue readingHow to recover lost or forget administrator SA Password In SQL Server?
I am going to show you how to recover Sysadmin Password through SSMS:- Kindly follow the below Steps: 1. Stop
Continue reading