What are the different authentication modes in sql server?

0 Answers  

---

How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---

A left outer join B B right outer join A gives the same result then what is the use of two?

1 Answers  

---

Which index created when Create Index on table(col), Why

2 Answers   CGI,

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

0 Answers  

---

Can multiple columns be used in sql group by clause in ms sql server?

0 Answers  

---

How do you start single user mode in clustered installations?

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

what is a check constraint?

0 Answers  

---

What is difference between clustered and non clustered index?

0 Answers  

---

What is normalization? Explain its different types?

0 Answers   GE, Maveric,

---