Customer reached out me with a very simple but very interesting question related to Detecting Database Isolation Level MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT.
Coffee Mug – Indexes and SELECT Queries
Sometimes I feel like I have become a kid again. This morning I received a coffee mug with printed quotes of Indexes and SELECT Queries.
SQL SERVER – 3 Questions: An Index Reduces Performance of SELECT Queries
Lots of people had no idea that even index can also reduce the performance of SELECT queries. In this blog, we discuss 3 follow up questions.
SQL SERVER – FIX: Msg 15274 – Access to the Remote Server is Denied Because the Current Security Context is not Trusted
In this blog we would talk about fixing error 15274 – Access to the remote server is denied because the current security context is not trusted.
How to List All Memory Optimized Tables in SQL Server? – Interview Question of the Week #227
Question: How to List All Memory Optimized Tables in SQL Server? We will see two different scripts here: One for Database and Second for Tables.
SQL SERVER – Error: 5173 – One or More Files do Not Match the Primary File of the Database
In this blog, we would discuss error: Error: 5173 – One or more files do not match the primary file of the database and its solution.
SQL SERVER – REBUILDDATABASE Error: 0x84CF0004 – While updating permission setting for folder The Permission Setting Update Failed for File
While updating the permission setting for the folder, the permission setting update failed for the file with the error REBUILDDATABASE.