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.

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

2 Answers   IBM,

---

Explain filestream storage of sql server 2008?

0 Answers  

---

Differentiate between a having clause and a where clause.

0 Answers  

---

How cand Optimize SQL Server Stored Procedures

1 Answers  

---

List the ways in which dynamic sql can be executed?

0 Answers  

---

How to select some specific columns from a table in a query in ms sql server?

0 Answers  

---

Explain different forms of normalization?

0 Answers  

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

---

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

0 Answers  

---

Can a table have 2 foreign keys?

0 Answers  

---

Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

---