Answer / 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

Why the trigger fires multiple times in single login?

0 Answers  

---

What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers  

---

How can u convert the Date to String?

6 Answers   Microsoft, TCS,

---

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

---

What is a Trace frag?Where can we use this?

1 Answers  

---

---

Explain what is cte (common table expression)?

0 Answers  

---

Tell me what is the stuff and how does it differ from the replace function?

0 Answers  

---

What do we need queues in sql service broker?

0 Answers  

---

Explain the microsoft sql server delete command?

0 Answers  

---

what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,

---

What are the main control-of-flow T-SQL constructs?

1 Answers  

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  

---