MSSQL Query Blog
-
-
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...
-
-
-
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],...
-
-
-
-
MSSQL Support End Dates in SQL Server
Hello everyone, In this article, I will try to give information about the MSSQL support termination dates in SQL Server. Below are Microsoft’s end of support dates for SQL Server versions. ↓SQL Server 2019 15.0.2000.5 Version: 15.0 Mainstream support end: Jan 14, 2025 Extended support end: Jan 8, 2030 ↓SQL...
Updating Statistics with Cursor in SQL Server
Hello everyone, In this article, I will try to give information about updating Statistics with Cursor in SQL Server. Although Statistics are updated automatically in SQL Server, sometimes they need to be updated manually. You can easily do this using the code below. DECLARE @sql NVARCHAR(500); DECLARE @tableName NVARCHAR(200); DECLARE...
Check Index Fragmentation on All Indexes in SQL Server
Hello everyone, In this article, I will try to give information about fragmentation detection in all Indexes in SQL Server. In SQL Server you may want to see fragmentation on all Indexes. You can do this easily using the code below. SELECT dbschemas.[name] AS ‘Schema’, dbtables.[name] AS ‘TABLE’, dbindexes.[name] AS...
CPU Usage Information in SQL Server
Hello everyone, In this article, I will try to give information about CPU usage information in SQL Server. In SQL Server, you may want to see CPU usage information in some cases. You can easily do this using the code below. DECLARE @ms_ticks_now BIGINT; SELECT @ms_ticks_now = ms_ticks FROM sys.dm_os_sys_info;...