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,

---

How to create a testing table with test data in ms sql server?

0 Answers  

---

What are functions

3 Answers  

---

What is the user of Primary key?

0 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

---

what is the Enterprise manager(2000) and management studio (2005)?

2 Answers  

---

How do you identify a foreign key?

0 Answers  

---

What are the results of running this script?

0 Answers  

---

What is analysis service repository?

0 Answers  

---

Write an sql query for deleting duplicate rows?

0 Answers  

---

What is recompile sql server?

0 Answers  

---

What is an example of a primary key?

0 Answers  

---