MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article, I will try to give information about finding the queries that consume the most CPU and Disk IO in SQL Server. It is very important to find queries that consume CPU, Disk IO in SQL Server. You can find these queries using the code below....
Hello everyone, In this article, I will try to give information about getting information about Job setup and configuration in SQL Server. If you are using Job in SQL Server, you may want to learn about its installation and configuration. You can also get this information using the code below....
The process we will do is to create the script of the key fields of a table, namely the Primary Key, Foreign Key and Index Key fields. Even though I don’t use it much, in SQL Server, in some cases, we may only need to create a script for the...
Hello everyone, In this article, I will provide information about text encryption and decryption in SQL Server. You can use this type of encryption for data security in SQL Server. The point you need to pay attention to here is that you will use the key when decoding the key...
Hello everyone, In this article, I will try to share information about searching words in all tables in SQL Server. In SQL Server, in some cases, we may want to find a word we want in all tables. You can easily do this using the procedure below. Note: It may...
Hello everyone, In this article, I will give you information about how to setup and run job in SQL Server. You can use the query below to learn about the installation and running of the jobs you have created in SQL Server. Our query will bring us many information such...
Hello everyone, In this article, I will talk about how to list updated tables in SQL Server. In SQL Server, in some cases, it may be desirable to know which tables have been updated. I will describe my transactions using the Northwind database. Let’s check if there is a change...
Hello everyone, In this article, I will talk about the use of the nested while loop in SQL Server. Using a nested while loop in SQL Server is the process of adding another loop inside a loop. The logic of the loop works as follows. The outermost loop returns first....