All the jobs information are stored in system tables of MSDB system database. Here we are going to use sysjobs and sysjobhistory tables to monitor information for each scheduled jobs execution. Below query will help...
SQL 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,...
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,...
If you want to identify when last time statistics were updated on objects in database then you can use either DBCC SHOW_STATISTICS header information or sys.stats catalog view. Below example displays all statistics information for the AK_Currency_Name...
If your database contains hundreds or thousands of tables then it’s difficult to find which tables are missing clustered index in a database manually. You can go through this article which provides very simple...
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...
More
