1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

---

What is sql stored procedure?

0 Answers  

---

What are different types of raid configurations? : SQL Server Architecture

0 Answers  

---

Can I save my report as html, excel or word? : sql server management studio

0 Answers  

---

---

Questions on identity?

2 Answers   Infosys,

---

what is difference between having and where clause ?

3 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

7 Answers   Microsoft,

---

How do I shrink an ldf file?

0 Answers  

---

How can I check that whether automatic statistic update is enabled or not?

0 Answers  

---

What is the difference between Normalization and De-normalization?

0 Answers   TCS,

---

What is a non clustered primary key?

0 Answers  

---