Answer / Himanshu Srivastava

SQL Server Operating System (SQLOS) is a lightweight operating system built within SQL Server that manages resources like memory, CPU, and I/O for multiple user connections simultaneously.n
1. Resource Governance: Manages resource consumption by individual queries or plans to ensure fairness and prevent runaway queries from consuming all server resources.n
2. Concurrency Control: Ensures concurrent access to database objects by implementing mechanisms like locks and latches.n
3. Asynchronous Processing: Supports asynchronous processing for I/O, queries, and jobs using worker threads and worker thread pools.

What is serializable?

1 Answers  

---

How to create a new login name in ms sql server?

1 Answers  

---

What is normalization? Explain different forms of normalization?

1 Answers  

---

What is “asynchronous” communication in sql server service broker?

1 Answers  

---

What is CTE in SQL

1 Answers   Infosys,

---

Why use “in” clause in sql server?

1 Answers  

---

What is 2nf example?

1 Answers  

---

What is the exact numeric data type in sql?

1 Answers  

---

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,

---

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

9 Answers   Brigade, Wipro,

---

What is perspective, have you ever created perspective? : sql server analysis services, ssas

1 Answers  

---

What does it mean to invest in the index?

1 Answers  

---