What are the differences between substr and charindex in sql server.

0 Answers  

---

How to find the list of fixed hard drive and free space on server?

0 Answers  

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

9 Answers   Hewitt,

---

explain different types of joins? : Sql server database administration

0 Answers  

---

What are the types of stored procedures in an sql server?

0 Answers  

---

Is it possible in sql table to have more than one foreign key?

0 Answers  

---

How to query multiple tables jointly?

0 Answers  

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

0 Answers   Genpact,

---

What is surrogate key? : sql server analysis services, ssas

0 Answers  

---

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,

---

What is a Join and explain its types?

0 Answers  

---