What do you understand by physical_only option in dbcc checkdb?

0 Answers  

---

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,

---

What are different types of data sources?

0 Answers  

---

What is the difference between temp table and table variable?

8 Answers   Microsoft,

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

---

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

---

when inserting to a table how many rows will be effected using triggers

2 Answers  

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

How can delete duplicate records in cte in sql server?

0 Answers  

---

Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,

---

What is the difference between for xml raw and for xml auto?

0 Answers  

---