What do you know about normalization and de- normalization?

0 Answers  

---

What is #temp and @table variable in SQL server?

0 Answers  

---

What are the underflow and overflow behaviors on float literals?

0 Answers  

---

Can we call future method from queueable?

0 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

---

How to create a new login name in ms sql server?

0 Answers  

---

What happens when transaction log is full?

0 Answers  

---

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---

How real and float literal values are rounded?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---