How to create an index on an existing table in ms sql server?

0 Answers  

---

Can we shrink data file in sql server?

0 Answers  

---

Explain the concept of recursive stored procedure.

0 Answers  

---

what are triggers? : Sql server database administration

0 Answers  

---

Do you know how to send email from database?

0 Answers  

---

---

What is normalization and what are the advantages of it?

0 Answers  

---

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers  

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

Why I am getting this error when dropping a database in ms sql server?

0 Answers  

---

Tell me when is the update_statistics command used?

0 Answers  

---

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? : Sql server administration

0 Answers  

---

What are the different types of joins and what does each do?

2 Answers  

---