Tag: SQL

Modern Markdown blogging with AI-powered localization and search.

Recent Featured

MAY

EF second layer cache to enhance your SQL database performance based on Redis ★

Entity Framework Core is a lightweight, extensible, open source, and cross platform version of the popular Entity Framework data access technology. It really helps the developer to build applications which access database easily. But in most cases, we may cache some results which...

ASP.NET Core Azure C# Cache Caching Entity Framework Core Redis SQL SQL Server

JAN

Tips to get better performance for Entity Framework Core ★

Only get the row you need And the key reason for your slow query is it outputs too much data. Consider adding: Take(200) , Skip() to take only the data you need or the current page requires. Use a pager to generate the report. This might helps a lot. Consider the following code (...

Database Entity Framework Entity Framework Core Performance Query Optimization SQL

DEC

How to fix SQL Server database suspect status

In case our SQL Server database can't access, and telling you that it was in suspect status: Common reasons for the state are: The system cannot open the device where the data or log file is located The specified file was not found during the creation or opening of the physical d...

DBCC CHECKDB Database Repair SQL SQL Server SSMS Suspect Status