What do you understand by the analysis services in sql server?

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  

---

How except clause is differs from not in clause?

0 Answers  

---

when you create a database how is it stored? : Sql server database administration

0 Answers  

---

Explain logical operators in sql server?

0 Answers  

---

---

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

---

How to know whether our backup is succesfully taken?

1 Answers  

---

What is mscorsvw.exe - process - microsoft .net framework ngen?

0 Answers  

---

What is usually the first word in a sql query?

0 Answers  

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,

---