What do you understand by the analysis services in sql server?

0 Answers  

---

What is key set driven?

0 Answers  

---

What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

What is the cartesian product of table?

0 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 command must you use to include the not null constraint after a table has already been created?

0 Answers  

---

What is the difference between the 2 operating modes of database mirroring?

0 Answers  

---

What are mdf,ndf,ldf files and how to see the data in those files?

6 Answers   Accenture,

---

What is the difference between Triggers and Stored Procedure?

0 Answers   HCL,

---

Explain what are the restrictions while creating batches in sql server?

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

How to sort the query output with order by clauses in ms sql server?

0 Answers  

---