Have you ever started SQL Server only to discover your database labeled “In Recovery,” you know how upsetting it can be—especially when the process appears to ...

A seasoned software engineer with extensive experience in building complex distributed data-intensive backend services. The most general way to satisfy a COUNT DISTINCT or SELECT DISTINCT clause is to ...

--Q3: Create a VIEW which includes all the ET-passed trainees.

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...

In this blog we illustrate how to get the pagination data from SQL server stored procedure. To create a such type of a stored procedure, we need to send a minimum ...

For on-premise SQL Server a file in a memory-optimized filegroup needs to be added to the database. We will dynamically create it in the migration if it doesn't exist. A convention will set indexes to ...