Explain the different index configurations a table can have?

0 Answers  

---

What are the two authentication modes in sql server?

0 Answers  

---

How does clustered and non clustered index work?

0 Answers  

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,

---

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,

---

---

What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  

---

Tell me what is sql profiler?

0 Answers  

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

0 Answers  

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

What is implicit mode in sql server?

0 Answers  

---

What is role playing dimension with two examples? : sql server analysis services, ssas

0 Answers  

---

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

0 Answers   Value Labs,

---