MSSQL Query Blog
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...