Explain filtered indexes benefits?

0 Answers  

---

What is CTE in SQL

0 Answers   Infosys,

---

can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---

Define Check points and End Points?

1 Answers  

---

user defined datatypes

1 Answers   Wipro,

---

When would you prefer to have a minimum number of indexes?

0 Answers  

---

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

---

There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9

12 Answers   RBS,

---

What is the use of “join” in sql server?

0 Answers  

---

How to view the error log for any specific instance? : sql server database administration

0 Answers  

---

List out the difference between union and union all in sql server?

0 Answers  

---