Database Administration / SQL Server / SQL Tips and Tricks
by Manzoor Siddiqui · Published January 30, 2016 · Last modified May 24, 2016
328viewsSQL Server provides very useful T-SQL to find out details about property information of SQL Server instance by querying SERVERPROPERTY. With this T-SQL you can find out information like Product Version, Server Name, Edition,...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / SQL Troubleshooting
by Manzoor Siddiqui · Published October 10, 2015 · Last modified December 4, 2015
SQL Server provides DMVs and system tables to find out when SQL Server was last restarted. We may need this information many times to troubleshoot or trace issues which occurs on database servers. So,...
Database Administration / SQL Server / SQL Tips and Tricks
by Manzoor Siddiqui · Published October 7, 2015 · Last modified October 29, 2015
We have a query which is very useful for DBAs and database users to find total number of connections used by particular login on database instance for all databases or on particular database. Here I am...
Database Administration / Performance Tuning / SQL Server / SQL Tips and Tricks
by Manzoor Siddiqui · Published October 6, 2015 · Last modified October 25, 2015
595views As a DBA, time to time we have to trace SQL queries which are consuming highest CPU utilization in SQL Server and need to tune those queries. You can refer below query which...
Database Administration / SQL Server / SQL Tips and Tricks
by Manzoor Siddiqui · Published October 5, 2015 · Last modified October 24, 2015
If you want to find SQL Jobs Name and owners by which particular job is running then you can find the same by joining sysjobs and syslogins from msdb and master database respectively as given below....
Database Administration / SQL Server / SQL Tips and Tricks
by Manzoor Siddiqui · Published October 4, 2015 · Last modified October 23, 2015
As a DBA sometimes we need to verify certain details for currently running jobs, jobs steps, jobs description and commands and queries used in jobs etc. We can extract these details by joining tables...
More
