what is datawarehouse?

0 Answers   Informatica,

---

What do you mean by the term 'normalization'?

0 Answers   Tech Mahindra,

---

Mention the differences between substr and charindex in sql server.

0 Answers  

---

Difference between group by clause and having clause in SQL?

0 Answers   Flextronics,

---

difference between Clustered index and non clustered index ?

0 Answers   Infosys,

---

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  

---

What is the default order of an order by clause?

0 Answers  

---

Can we check locks in database? If so, how can we do this lock check?

0 Answers  

---

What are different type of Collation Sensitivity?

0 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? : Sql server administration

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

Are resultset updatable?

0 Answers  

---