as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  

---

How can I enforce to use particular index?

1 Answers   Symphony,

---

How will u find the query which is running in some other machine

4 Answers   CarrizalSoft Technologies, IBM,

---

What is field with example?

0 Answers  

---

How can we use ConnectorJ JDBC Driver with MS SQL?

0 Answers   PUCIT,

---

Explain what are commit and rollback in sql?

0 Answers  

---

What is difference in performance between insert top (n) into table and using top with insert?

0 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

---

How to check status of stored procedure in sql server?

0 Answers  

---

How to write a query with a right outer join in ms 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,

---