MSSQL Query Blog
-
-
Viewing Memory Usage in SQL Server
Hello everyone, In this article, I will try to give information about viewing Memory usage in SQL Server. In SQL Server you may want to view Memory usage in some cases. You can easily do this using the code below. select (physical_memory_in_use_kb / 1024) Phy_Memory_usedby_Sqlserver_MB, (locked_page_allocations_kb / 1024) Locked_pages_used_Sqlserver_MB, (virtual_address_space_committed_kb...
-
-
-
-
Listing All Users in SQL Server
Hello everyone, In this article, I will try to give information about listing all users in SQL Server. In SQL Server you may want to list all users in some cases. You can easily do this using the code below. SELECT name AS username, create_date, modify_date, type_desc AS type, authentication_type_desc...
-
-
-
-
Viewing Stored Procedure Parameters in Detail in SQL Server
Hello everyone, In this article, I will try to give information about displaying Stored Procedure parameters in SQL Server in detail. In SQL Server, in some cases, you may want to view the Stored Procedure parameters in detail. You can easily do this using the code below. SELECT ‘Parameter_name’ =...
Listing System Administrators in SQL Server
Hello everyone, In this article, I will try to give information about listing System Administrators in SQL Server. In SQL Server you may want to list System Administrators in some cases. You can easily do this using the code below. SELECT name, type_desc, is_disabled FROM master.sys.server_principals WHERE IS_SRVROLEMEMBER(‘sysadmin’, name) =...
Seeing Procedure Execution Statistics in SQL Server
Hello to everyone, In this article, I will try to give information about seeing Procedure Execution Statistics in SQL Server. In SQL Server you may want to see Procedure Execution Statistics in some cases. One advantage of Stored Procedures is that performance can be tracked. There may be many Stored...
