With the help of below script we are able to get the SQL Server jobs and respective owner details in
Continue readingCategory: SQL Server -DBA
SQL Server -DBA, SQL Server Services, who dropped or altered tables,procedures or databases in SQL Server, What in SQL Server
Find Percentage Completion Of Currently Running Processes Or Job In SQL Server
In SQL Server Some tasks that are running take a long time to run and it is sometimes difficult to
Continue readingSQL Server :- Get Statistics Of All Objects Of A Database In SQL Server
With the help of Below Query you are able to find the details about Statistics of a database in SQL
Continue readingHow to get when your SQL server was last restarted?
Through below script you are able to find SQL Server Last Restart Time:- SELECT sqlserver_start_time from sys.dm_os_sys_info;
Continue readingSQL Server :- How to check User database size in SQL Server?
Through below Script we are able to find out the User database Size in SQL Server. Check User database size
Continue readingSQL SERVER :- Temporary Stored Procedures in SQL Server
In this post, I am going to discuss about SQL Server Temporary Stored Procedure with examples. Temporary Stored Procedures:- The
Continue readingHow to find List of SQL Server Instances Installed on a Machine?
There are multiple ways by which we can find a list of SQL Server instances Installed on a Machine. 1.
Continue readingSQL query resulted in error: Exception of type ‘System.OutOfMemoryException’ was thrown
Problem:- Executing SQL Server query through Microsoft SQL Server Management Studio then it returns the following error: An error occurred
Continue readingSystem Databases OR System Objects Are Not Visible in SQL Server Management Studio
Problem:- System Databases OR System Objects Are Not Visible in SQL Server Management Studio. Reason:- System objects may be hidden.
Continue readingsys.dm_os_wait_stats In SQL Server
sys.dm_os_wait_stats :- There are many Dynamic Management View (DMV) available in SQL Server but The key Dynamic Management View (DMV)
Continue reading