Category: SQL Server

SQL Server related articles and SQL Server related code examples and TSQL Codes

Listing Agent Error Logs in SQL Server

Hello everyone, In this article, I will try to give information about listing Agent error logs in SQL Server. In SQL Server, in some cases, you may want to list Agent error Logs. The following TSQL codes will search all available SQL Server Error Logs or SQL Server Agent Error...

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...

Converting Hexadecimal to Decimal Value in SQL Server

Hello to everyone, In this article, I will try to give information about converting Hexadecimal value to Decimal value in SQL Server. In SQL Server, you may want to convert Hexadecimal to Decimal in some cases. You can easily do this using the code below. DECLARE @deger CHAR(12); SET @deger...

Listing Tables Without Indexes in SQL Server

Hello to everyone, In this article, I will try to give information about listing tables that do not contain Index in SQL Server. In SQL Server, in some cases, you may want to list tables that do not contain an Index. You can easily do this using the code below....

Don`t copy text!