You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

0 Answers  

---

What is the difference RDBMS and Graph Database?

0 Answers   EXL,

---

What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,

---

What it means to be triggered?

0 Answers  

---

Explain the difference between functions and stored procedures in sql server?

0 Answers  

---

Explain the truncate command? : SQL Server Architecture

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

In the primary key have a multiple field or not?

8 Answers   TCS,

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

0 Answers  

---

What is the server name in sql server?

0 Answers  

---

Where sql server usernames and passwords are stored in a sql server?

0 Answers  

---

How does using a separate hard drive for several database objects improves performance right away?

0 Answers  

---