what is sql server agent why can't we create objects of abstract class write extension method for abstract class SQL: SP vs Function, which one is faster, why? can I call SP from Function Microservice orchestration, choreography, resiliency, circuit-breaker pattern IEnumerable vs IQueryable

Question

Accepted Answer

SQL Server Agent is a job scheduling tool in SQL Server. Abstract classes cannot be instantiated. SPs are faster than functions. Microservice concepts. IEnumerable vs IQueryable.

SQL Server Agent is a job scheduling tool in SQL Server for automating tasks like backups, database maintenance, etc.
Abstract classes cannot be instantiated because they are incomplete and meant to be extended by subclasses.
Extension methods can be created for abstract classes to add new functionality without modifying the class itself.
Stored Procedures (SPs) are generally faster than Functions in SQL because SPs are precompiled and optimized.
You cannot directly call a Stored Procedure from a Function in SQL.
Microservice orchestration involves coordinating multiple services, while choreography allows services to communicate directly.
Resiliency in microservices involves designing systems to handle failures gracefully.
Circuit-breaker pattern is used to prevent cascading failures in distributed systems.
IEnumerable is used for in-memory collection manipulation, while IQueryable is used for querying databases.

what is sql server agent why can't we create objects of abstract class write extension method for abstract class SQL: SP vs Function, which one is faster, why? can I call SP from Function Microservice orchestration, choreography, resiliency, circuit-breaker pattern IEnumerable vs IQueryable

Top Simform Senior Software Engineer interview questions & answers

Popular interview questions of Senior Software Engineer

Top HR questions asked in Simform Senior Software Engineer