MSSQL Query Blog

28 May 2022

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

SQL Server

26 May 2022

Listing Unsuccessful Jobs in the Last 24 Hours in SQL Server

Hello to everyone, In this article, I will try to give information about listing unsuccessful jobs in SQL Server in the last 24 hours. In SQL Server, in some cases, you may want to list unsuccessful Jobs in the Last 24 Hours. You can easily do this using the code...

SQL Server / Stored Procedures

21 May 2022

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

SQL Server

20 May 2022

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

SQL Server

11 May 2022

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

SQL Server

5 May 2022

Listing the 200 Most CPU-Using Queries in SQL Server

Hello to everyone, In this article, I will try to give information about listing the 200 most CPU-consuming queries in SQL Server. In SQL Server, in some cases you may want to list the 200 queries that use the most CPU. You can easily do this using the code below....

Functions / SQL Server

5 May 2022

Function that Encodes Text to Base64 in SQL Server

Hello to everyone, In this article, I will try to give information about the function that encodes text to Base64 in SQL Server. In SQL Server, in some cases, you may want to encode text to Base64. You can easily do this using the code below. CREATE FUNCTION [dbo].[fnBase64Encode] (...

SQL Server

2 May 2022

Listing All Days of a Year in SQL Server

Hello to everyone, In this article, I will try to give information about listing all the days of a year in SQL Server. In SQL Server, in some cases you may want to list all the days of a year. You can easily do this using the code below. WITH...