What is role playing dimension with two examples? : sql server analysis services, ssas

0 Answers  

---

Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,

---

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

---

What are recommended options to be used while using db mirroring? : sql server database administration

0 Answers  

---

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---

Differentiate between a local and a global temporary table?

0 Answers  

---

Difference between drill down and drill through report.

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

How many primary keys are possible in a table?

0 Answers  

---

What is Command line parameters in PLSQL.?

0 Answers   MCN Solutions,

---

Where cross join is used?

0 Answers  

---