Author: Yavuz Selim Kart

Listing Tables Created in the Last Month in SQL Server

Hello everyone, In this article, I will try to give information about listing the tables created in SQL Server in the last month. In SQL Server, in some cases, you may want to list the tables created within the last month. You can easily do this using the code below....

Recovery Pending Error in SQL Server

Hello everyone, In this article, I will provide information about Recovery Pending error in SQL Server. The reason for Recovery Pending error in SQL Server may be due to power outages, insufficient resources of the database server, or overloading because you did not disconnect the database connections on your software....

Detecting Unused Tables in SQL Server

Hello everyone, In this article, I will try to give information about detecting unused tables in SQL Server. In SQL Server, you may want to detect unused tables in some cases. You can easily do this using the code below. SELECT tablolar.name AS TabloAdi, bolumler.rows AS KayitSayisi FROM sys.tables tablolar...

Backing Up with Code in SQL Server

Hello everyone, In this article, I will try to give information about backing up with code in SQL Server. In SQL Server, in some cases, you may want to return with the backup code you have. You can easily do this using the code below. –Code 1 (restore backup via...

Detecting Unused Indexes in SQL Server

Hello everyone, In this article, I will try to give information about detecting unused Indexes in SQL Server. In SQL Server, in some cases, you may want to detect unused Indexes. You can easily do this using the code below. SELECT o.name AS ObjectName, i.name AS IndexName, i.index_id AS IndexID,...

To See Which Tables Have Been Processed Last in SQL Server

Hello everyone, In this article, I will try to give information about seeing which tables were processed last in SQL Server. In SQL Server, in some cases, you may want to see which tables were processed last. You can easily do this using the code below. SELECT DB_NAME(ius.[database_id]) AS [Database],...

Versions that Need to be Updated in SQL Server

Hello everyone, In this article, I will try to give information about the versions that need to be updated in SQL Server. There are some versions of SQL Server that are known to cause corruption in SQL Server in certain situations. These are versions of SQL Server 2012 and SQL...

Comma-Separating Table Columns into Lists in SQL Server

Hello everyone, In this article, I will try to give information about separating table columns with commas and making them a list in SQL Server. In SQL Server, in some cases, the number of columns in your table may be high. Instead of typing the column names one by one...

Don`t copy text!