Category: DBMS Concepts
-
Detach and Attach in SQL Server
Hello there, everyone! I hope everything is going well for you. Today, I’ll show you about Detach and Attach Detach SQL Server Database- A SQL Server database is made up of at least two files: a data file (mdf) and a log file (ldf), though there may be additional data files in some circumstances. Since…
//
-
SQL Interview Questions
You can benefit from this article’s popular SQL Server DBA interview questions and answers. To learn more about SQL interview questions, I would advise you to read this post as well as the SQL Server Interview questions and answers. I made an effort to be very specific in my responses to each question in this…
//
-
SQL Server’s in-memory OLTP technology
Hey guys, In this blog I am going to explain you about SQL Server’s in-memory OLTP technology. Introduction- A native stored procedure compiler and specialized, memory-optimized relational data management engine are both built into SQL Server as part of In-Memory OLTP. For the most demanding OLTP workloads, Microsoft created In-Memory OLTP. In many instances, the…
//
-
Extended Events in SQL Server
Introduction- Extended Events (XEvents) is a highly scalable and adaptable event-driven monitoring system that debuted with SQL Server 2008. It is intended to assist database administrators (DBAs) and developers in gathering extensive information on SQL Server behavior, such as performance issues, query execution, and system diagnostics. Extended Events’ architecture provides for minimum performance effect, making…
//