tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

0 Answers   MCN Solutions,

---

Is trigger fired implicitely?

2 Answers  

---

What is nested transaction?

0 Answers  

---

---

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

What is compound operators?

0 Answers  

---

How to select Distinct columns from the table, table having 20 columns and i want all coulmns

5 Answers   Wipro,

---

What are the system database in sql server 2005?

0 Answers  

---

Can you please differentiate between a primary key and a unique key?

0 Answers  

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---