Why do we use non clustered index?

0 Answers  

---

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

0 Answers  

---

How to filter records of table in SQL SERVER?

0 Answers   Petranics Solutions,

---

How can we improve performance by using SQL Server profiler?

0 Answers   QuestPond,

---

What is openrowset sql server?

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  

---

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

---

What are the components of dbms?

0 Answers  

---

Explain go command in sql server?

0 Answers  

---

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,

---

Mention a few common trace flags used with sql server?

0 Answers  

---

Can we drop user if user mapped to any logins

1 Answers  

---