how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

How retrieve field names from the table in SQL through JAVA code?

0 Answers  

---

How to create logins using windows Authentication mode?

2 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

Explain filtered indexes benefits?

0 Answers  

---

What is the purpose of the model database?

0 Answers  

---

What are the new features in sql server 2016?

0 Answers  

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

Do you know what is bit data type and whats the information that can be stored inside a bit column?

0 Answers  

---

What does indexation mean?

0 Answers  

---

what is cluster and nin-cluster index?

4 Answers  

---