Answer Posted / srinivas

desc <table_name>

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

902

---

Explain alternate key, candidate key and composite key in sql server?

862

---

What are parameterized reports? What are cascading parameters in ssrs reports?

148

---

What is read uncmmited?

1013

---

What is a collation?

1038

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

938

---

where the connection string store in the database

2019

---

What are the fixed server level roles? : sql server security

1054

---

What is the difference between substr and charindex in the sql server?

1003

---

How to recompile stored procedure at run time?

1006

---

How to delete duplicate rows from table except one?

933

---

What are the different Topologies in which Replication can be configured?

1120

---

What is pivot and unpivot?

978

---

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?

918

---

What do you understand by the analysis services in sql server?

895

---