Following query will help in finding the last Sql Server restarted date.
This is very useful query when you are looking for unused indexes. Before dropping unused indexes, always check last sql server restarted by using following query.
SELECT sqlserver_start_time FROM sys.dm_os_sys_info
This is very useful query when you are looking for unused indexes. Before dropping unused indexes, always check last sql server restarted by using following query.
SELECT sqlserver_start_time FROM sys.dm_os_sys_info
No comments:
Post a Comment
Enter your comments here...