What is the most common trace flags used with sql server?

0 Answers  

---

explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  

---

What is subquery explain with example?

0 Answers  

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

---

Why I have to use stored procedures?

0 Answers   Cognizant,

---

---

Introduction of rollup clause using sum and group by clause?

0 Answers  

---

If we delete pack Spec what will be the status of pack Body ?

0 Answers   Nagarro,

---

What is the new security features added in sql server 2016? : sql server security

0 Answers  

---

How do you check the performance of a query and how do you optimize it?

1 Answers  

---

Explain query editor regions

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

Can we call SP inside a query?

5 Answers   CA, CarrizalSoft Technologies, Wipro,

---