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

0 Answers  

---

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

---

What is transaction server auto commit?

0 Answers  

---

Explain some DBCC commands?

6 Answers  

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

---

How to create database with physical files specified in ms sql server?

0 Answers  

---

How to generate create table script on an existing table in ms sql server?

0 Answers  

---

How to select some specific columns from a table in a query in ms sql server?

0 Answers  

---

what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  

---

What are the approximate numeric data types?

0 Answers  

---

Explain what is the difference between a local and a global temporary table?

0 Answers  

---

What are the different types of collation sensitivity in sql server?

0 Answers  

---