You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  

---

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

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

6 Answers  

---

Define magic tables in sql server?

0 Answers  

---

What are points to remember while using the fillfactor argument?

0 Answers  

---

how can you move the master database

1 Answers   IBM,

---

What are the operating modes in which database mirroring runs?

0 Answers  

---

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  

---

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---

How do I find information about the install locations for the various instances running on a computer?

0 Answers  

---