What is use of attributehierarchyenabled? : sql server analysis services, ssas

0 Answers  

---

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  

---

What is a non equi join?

0 Answers  

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

0 Answers   Facebook,

---

user defined datatypes

1 Answers   Wipro,

---

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

What is the difference between ddl,dml and dcl commands?

0 Answers   BirlaSoft, Verifone,

---

What is the difference between TRUNCATE and DROP?

0 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

What is the difference between count and distinct count?

0 Answers  

---

How can we use ConnectorJ JDBC Driver with MS SQL?

0 Answers   PUCIT,

---

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  

---