Answer / supriya gupta

SQL Server is a relational database management system
(RDBMS) from Microsoft that's designed for the enterprise
environment. SQL Server runs on T-SQL (Transact -SQL), a set
of programming extensions from Sybase and Microsoft that
add several features to standard SQL, including transaction
control, exception and error handling, row processing, and
declared variables.

Explain about nested stored procedure?

0 Answers  

---

What are points to remember while using the fillfactor argument?

0 Answers  

---

What is difference between rollback immediate and with no_wait during alter database?

0 Answers  

---

What is difference between views and tables?

0 Answers  

---

What type of locking occurs during the snapshot generation? : sql server replication

0 Answers  

---

---

How to create indexed view?

0 Answers  

---

Explain about SQLOS?

0 Answers  

---

Explain the difference between HTTP and HTTPS in database?

0 Answers   Wipro,

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

---

Detail about query optimizer?

0 Answers  

---

Explain about protocol layer present in SQL server?

0 Answers  

---

How many non clustered indexes there can be on table ?

0 Answers  

---