Answer / rajesh s. chandan

Unique identitiy key is generated during data load process
(ETL) in the datawarehouse system is called as Surrogate
key.
It is mainly used to update slowing changing dimesion
attribute data and also it removes dependencies on key
originating in different data sources.

Primary key is uniquely identified each record in a table
with no null values.

Answer / jayaraj

Primary key is a type of key where the data inside the
column should be unique and should not be null.we generally
use the primary key to access any of the rows of a table by
using the primary key column.when a table don't have a
primary key then we assign a primary key to the table which
is known as surrogate key for accessing any row of the
table. means the key will act like a primary key for the
table.

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  

---

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

---

How do you know which index a table is using?

4 Answers  

---

How to assign new column names in a view?

0 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

What is a cursor, index in sql?

0 Answers  

---

What is the maximum row of a size?

0 Answers  

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

What is the contrast between sql and mysql?

0 Answers  

---

Tell me what are the advantages of using stored procedures?

0 Answers  

---

How to find the service pack installed? : sql server database administration

0 Answers  

---

Can I work with several databases simultaneously? : sql server management studio

0 Answers  

---