Answer / saravakumar

You can use index hint (index=index_name) after the table
name. SELECT au_lname FROM authors (index=aunmind)

How do I partition a table in sql server?

0 Answers  

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

0 Answers  

---

How to loop through result set objects using mssql_fetch_array()?

0 Answers  

---

What are logical/boolean operations in ms sql server?

0 Answers  

---

Explain “not null constraint” in sql server?

0 Answers  

---

---

What is relationship? What number of sorts of relationship are there?

0 Answers  

---

What is surrogate key? : sql server analysis services, ssas

0 Answers  

---

What is the full form of ddl?

0 Answers  

---

Can you explain powershell included in sql server 2008?

0 Answers  

---

Suggest a method of joining two tables.

0 Answers   Ernst Young, Thomson Reuters,

---

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  

---

Explain primary key and foreign key constraints?

0 Answers  

---