Answer Posted / subramaniam

sql job is scheduling the work into server and it will
automatically run and finish the job
for this we have to set the time.
what is the use of the job is
1) it check the database automatically
2)take a back up of database

for this job we have to start the Sqlserver agent and
give the date and time for this particular job

What is attribute hierarchy? : sql server analysis services, ssas

961

---

How to backup encryption key ?

168

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

897

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

983

---

Would you store your query in a ssrs report or a database server? State the reason why?

148

---

Describe different Processing Modes offered by SSRS?

232

---

What are the different types of join?

1100

---

What is the difference between left and right outer join?

1017

---

Explain how to maintain a fill factor in existing indexes?

927

---

can you implement data mining in SSRS?

140

---

Define master database?

989

---

what is nonclustered index

897

---

What is difference between joins and subqueries?

1050

---

How many tables can be joined in SQL Server?

1004

---

Can you explain what is indexed view? How to create it?

851

---