View in SQL By Sagar Jaybhay 2020

Sql Server By Sagar Jaybhay

In this article Sagar Jaybhay explain what is View. What is the use of View. what is the advantages of views in SQL server. View The view is saved SQL query or we can call it a virtual table. We have these 2 tables and by joining these 2 tables we want to output. By joining these 2 tables we get the above result. Now we want to create a view, like other create statement like create a table, create procedure we have to create view statement Below is a…

Read More

What is Idisposable interface & Finalize Dispose pattern ?

Csharp By Sagar Jaybhay

In this article we will understand what is the use of IDisposable interface and how Finalize Dispose pattern will implement in C# By Sagar Jaybhay. Idisposable interface and Finalize Dispose pattern Garbage collector only cleans managed code and if any unmanaged code it finds it doesn’t reclaim its memory so to remove unused objects we need something. In this case, at least we have a responsibility to call these kinds of which free unmanaged code objects. In C# application there is a place where we can manage these unmanaged objects…

Read More

All About Index In SQL Server 2020

Sql Server By Sagar Jaybhay

In this article you will understand what is Index In SQL Server. How To Create Index and Different Types of Indexes In SQL By Sagar Jaybhay. Also You will leran Unique and Non Unique Index what is the difference between them. Index In SQL Server Index is used to find data from the table quickly. An index is created on views and tables. It is similar to the book index. If you apply index it will improve the query performance drastically. If there is no index then the query engine…

Read More

Managed Unmanaged code Garbage Collector Generations

Csharp By Sagar Jaybhay

What is the difference between Managed code and Unmanaged code Garbage Collector and Generations in C#? In this article you will understand What is the difference between Managed code and Unmanaged code Garbage Collector and Generations in C# Interview Questions Part 1 – https://sagarjaybhay.com/interview-questions-for-experienced-beginner-net-professionals-series-part-1/ Managed Code: The code which runs under the control of CLR is called a managed code. The code which is written in the .NET framework is managed code. Managed code uses CLR which looks after your applications by managing your application memory handling security and allow…

Read More

Interview Questions For Experienced and Beginner .NET Professionals Series Part 1

Csharp By Sagar Jaybhay

What is  IL code, CLR, CTS, CLS, JIT ? How Exactly Dot Net application compiles and Run? We write our code in C# or VB.net Then we compile our program then the compiler will convert our C# or VB.Net program into half compile code i.e IL (Intermediate Language ). When you click on Exe .net execution engine start then CLR gets this half compile code  and gives to JIT A machine can’t understand Intermediate code so JIT goes line by line and convert half compile code into machine-specific instruction. Finally,…

Read More