Answer / renu

SQL Server Agent is a Microsoft Windows Service that
executes scheduled administrative tasks called jobs.

It is made up of 3 components :

1)Jobs - Scheduled tasks

2)Alerts - set of actions occur when an event occurs.

3)Operators -People who alerts are sent to

Answer / sabin

Managing all scheduled jobs, monitoring for alerts and
notifying operators

How do you optimize Sql queries ?

0 Answers   Cognizant,

---

What is the default sql server instance name?

1 Answers  

---

one table has four field id,name,design,salary. i have to find maximum salary .

6 Answers  

---

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,

---

Do you know what are acid properties?

1 Answers  

---

Why would you call update statistics?

1 Answers  

---

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

1 Answers  

---

What command would you use to create an index?

1 Answers  

---

what is a mixed extent? : Sql server administration

1 Answers  

---

Do you know what is bit data type and whats the information that can be stored inside a bit column?

1 Answers  

---

What is isolation levels?

1 Answers  

---

How to include date and time values in sql statements?

1 Answers  

---