What do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

---

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

---

Can you explain some of the DTS problems?

1 Answers   UBS, Wipro,

---

How to create logins using windows Authentication mode?

2 Answers  

---

What is dataset and its uses

2 Answers  

---

what is the maximum size of a row in sql server 2000 and 2005

2 Answers  

---

what is the main difference between after trigger and instead trigger.

2 Answers  

---

What do you mean by COLLATION?

4 Answers   ABC, BirlaSoft,

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

0 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

0 Answers  

---

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

0 Answers   Value Labs,

---