How to optimize stored procedure optimization?

0 Answers  

---

How can you check the level of fragmentation on a table?

0 Answers  

---

Define tempdb database?

0 Answers  

---

What is the syntax to execute the sys.dm_db_missing_index_details?

0 Answers  

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

---

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  

---

How to insert data into an existing table?

0 Answers  

---

What is the importance of a recovery model?

0 Answers  

---

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 Answers  

---

What is sleeping status in sql server?

0 Answers  

---

What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 Answers  

---

what operator performs pattern matching?

2 Answers  

---