Answer / Pallavi Singh

Transaction Server Auto Commit refers to the automatic committing of a transaction after each SQL statement in a distributed environment, where transactions are managed by the Transaction Server instead of the local SQL Server instance.

Explain data warehousing in sql server?

1 Answers  

---

How can we rewrite sub-queries into simple select statements or with joins?

1 Answers  

---

What does <> symbol mean?

1 Answers  

---

How to Handle the exceptions in Sqlsrver 2005??

3 Answers   Value Labs, Wipro,

---

What are the steps to insert a table?

1 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

How do I create an extended event in sql server?

1 Answers  

---

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1 Answers  

---

whats the maximum size of view state??

1 Answers  

---

Which trace flags are enabled in sql server?

1 Answers  

---

What do you understand by the denormalisation?

1 Answers  

---