What happens if an integer is too big for int date type?

0 Answers  

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---

Can you name a few encryption mechanisms in sql server?

0 Answers  

---

What is the difference between views and stored procedures? Can we have input parameters for views?

6 Answers  

---

Define self join?

0 Answers  

---

---

Why de-normalization required?

0 Answers  

---

How will you monitor replication latency in transactional replication? : sql server replication

0 Answers  

---

can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

---

What is data compression? : sql server database administration

0 Answers  

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

Explain the use of containers in ssis and also their types?

0 Answers  

---

Is sql server is free?

0 Answers  

---