Answer / Saurabh Kumar Dubey

A Surrogate Key in SQL Server Analysis Services (SSAS) is a unique identifier that is assigned to each dimension record without any semantic meaning. It is typically an integer column and serves as a primary key for the dimension table.

What is sql sandbox in sql server?

1 Answers  

---

What is a livelock?

1 Answers  

---

How can we delete a table in sql server?

1 Answers  

---

user defined datatypes

1 Answers   Wipro,

---

Determine when an index is appropriate?

1 Answers  

---

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

---

From where can you change the default port?

3 Answers  

---

What is data integrity? Explain constraints?

1 Answers   Thinksoft,

---

syntax and example for bitmap index in sql???

1 Answers  

---

Do you know what is sql service broker?

1 Answers  

---

What does nvl stand for?

1 Answers  

---

What is the purpose of object explorer and its features? : sql server management studio

1 Answers  

---