What are the types of database schema? : sql server analysis services, ssas

0 Answers  

---

What is transact-sql ddl trigger?

0 Answers  

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

1 Answers  

---

What is the difference between dataadapter and datareader?

0 Answers  

---

Explain what is lock escalation and what is its purpose?

0 Answers  

---

---

What is the default server name for sql server?

0 Answers  

---

In what three ways is the return statement used in a stored procedure?

0 Answers  

---

How to check status of stored procedure in sql server?

0 Answers  

---

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

0 Answers   Cognizant,

---

How to configure odbc dsn with different port numbers?

0 Answers  

---

Can we write ddl in trigger?

0 Answers  

---

Is it possible to have clustered index on separate drive from original table location?

0 Answers  

---