Where do you find the default Index fill factor and how to change it?

0 Answers  

---

Does group by or order by come first?

0 Answers  

---

Give an example of why you would want to denormalize a database

0 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

What is the data type of time?

0 Answers  

---

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

0 Answers  

---

what are defaults? : Sql server database administration

0 Answers  

---

What language is sql server written in?

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

0 Answers  

---

What is logon trigger?

0 Answers  

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---