How to create a new table in a given schema?

0 Answers  

---

Define left outer join in sql server joins?

0 Answers  

---

If we delete pack Spec what will be the status of pack Body ?

0 Answers   Nagarro,

---

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

0 Answers  

---

Please differentiate between a local and a global temporary table?

0 Answers  

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

What is the purpose of optimization?

0 Answers  

---

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

0 Answers  

---

‘Order by’ is not allowed in a view how can you sort information from a view?

0 Answers  

---

What will be the maximum number of indexes per table?

0 Answers  

---

Describe about first three Normal forms.

1 Answers   HP,

---