Use below queries one by one and hopefully, you will be able to find and fix your Database Mail issue. sysmail_help_queue_sp @queue_type = ‘Mail’ select…
As part of SQL server database maintenance, the indexes have to be defragmented on regular basis by rebuild or reorganize for consistant performance. Most of…
Below query will be helpful in finding all missing indexes in a database. I got this query from one of my friend. I am not…
I had a requirement from application team that I should rename a database when the application is running and the transactions were happening. The reason…
Below workaround will help you incase if you wanna control SQL agent job steps based on a SQL query output. For eg: Suppose you have…
Below Query will help you read live file level Disk read and write information. WIll behandy for performance tuning capacity planning. select db.name,files.filename,* from sys.dm_io_virtual_file_stats(NULL,…
Issue It’s quite common that we use detach-attach method to migrated SQL server databases from Windows Server 2000 or 2003 to Windows server 2008. During…
 Questions Explain SQL Server Failover Clustering? How do we check index Fragmentation? TSQL syntax for Index rebuild and reorg. Difference between the two. How users…
The Attached SQL Query can be safely used for rebuilding or reorganizing all indexes in a particular database based on the fragmentation level. Note: The…
Run below Query. And once the query executes completely, go through the SQL Server Error log to see the results. declare databases cursor for select…