what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

0 Answers  

---

How can we get count of the number of records in a table?

0 Answers  

---

What is difference between order by and group by?

0 Answers  

---

What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  

---

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 Answers  

---

---

What is lock escalation and what is its purpose?

0 Answers  

---

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

0 Answers  

---

How is a full-text index updated?

0 Answers  

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,

---

What is exporting utility?

0 Answers  

---

Is it possible to update the views? If yes, how, if not, why?

0 Answers  

---

How get current date in SQL server 2000

4 Answers   Cap Gemini, Polaris,

---