Answer / manisha

From Redo-log files we can read the transaction details.

Which are the third-party tools used in sql server and why would you use them?

0 Answers  

---

About types of indexes in SQL server ?

2 Answers   Cognizant,

---

What is used to replicate sessions between instances in coldfusion clusters?

0 Answers   HCL,

---

How to find the source of a table in sql server?

0 Answers  

---

How to optimize stored procedure optimization?

0 Answers  

---

How to use go command in "sqlcmd"?

0 Answers  

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

0 Answers  

---

What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---

Why do we partition data?

0 Answers  

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

3 Answers   HCL,

---

How to generate create function script on an existing function?

0 Answers  

---