Shivam Dogra 
In this SQL Server article, I will share my experience with the error “SQL Operand data type real is invalid for modulo operator“. We will see, how to fix the error, sql operand data type float is invalid for modulo operator. The modulus operator behaves differently with different data types. Recently, I was trying to … Read more >>
In this SQL Server tutorial, we will understand How to test stored procedure in SQL Server. Additionally, we will also discuss the following topics How to test performance of stored procedure in SQL Server In SQL Server, we can check and test the performance of a stored procedure by using the SQL Server Management Studio. Moreover, in … Read more >>
In this SQL Server tutorial, we are going to talk about SQL Server scheduled stored procedure. Here we will learn about different methods of scheduling a stored procedure in SQL Server. And we will also understand the following topics. SQL Server scheduled stored procedure In this section, we will try to understand how to schedule a stored … Read more >>
In this tutorial, we are going to learn about SQL Server stored procedure case statement. Here we will discuss how to use a CASE statement in SQL Server Server Stored Procedure. And we will also discuss the following topics. But before understanding how to use a CASE statement in a stored procedure, we should know what … Read more >>
In the SQL Server tutorial, we will discuss how to rename stored procedure in SQL Server. And we also cover different ways to rename a stored procedure with examples. The list of topics that we will cover is given below. So, if you are not familiar with the stored procedure first, understand What is a stored … Read more >>
Before you rename a column or drop a table, you need every procedure that touches it. To find text in a stored procedure in SQL Server, search the definition column of sys.sql_modules with LIKE. The shortcuts people grab first let you down: INFORMATION_SCHEMA.ROUTINES only sees the first 4,000 characters, and a plain text match can’t … Read more >>
In this sql server tutorial, we will discuss how to fix error, the remote procedure call failed sql server configuration manager. the remote procedure call failed sql server configuration manager A few days back I got an error while using SQL Server Configuration Manager to list the services. The error states “The remote procedure call … Read more >>
In this SQL Server tutorial, we will learn about full-text search in SQL Server. Here we will learn How to enable and implement a full-text search in SQL Server. And for the implementation, we will be using SQL Server 2019. Here is the list of topics that we are going to discuss. What is full-text search in SQL … Read more >>
In this SQL Server tutorial, we will learn How to check if SQL Server is running or not. We will also discuss how we can check the status of different SQL Server services like an agent, browser, etc. And we will also illustrate the following topics given below. Note:- For all the demonstrations in the … Read more >>
In this SQL Server tutorial, we will learn How to get list of users, How to get a list of objects available in SQL Server. We will also demonstrate these topics with the help of examples. How to get list of users in SQL Server In this section, we will understand how to fetch all the … Read more >>