How will you optimize a stored procedure optimization?

0 Answers  

---

What do you mean by SQL injection attack?

0 Answers   Ittiam Systems,

---

What does it mean to be in union?

0 Answers  

---

How to view the error log for any specific instance? : sql server database administration

0 Answers  

---

diffrence between function and procedure

5 Answers   Wipro,

---

How to use wildcard characters in like operations in ms sql server?

0 Answers  

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

0 Answers  

---

How to select top 5 coloumn from a table without using coloumn name

5 Answers  

---

What is order of B+tree?

0 Answers   HCL,

---

What are information schema views?

0 Answers  

---

how insert selected column only ?

3 Answers   Robert Half,

---