Can we create clustered index on composite key?

0 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

i need some interview questions on sql server developer plz any onee send some links.

2 Answers  

---

How to modify existing triggers using "alter trigger"?

0 Answers  

---

How can you get @@error and @@rowcount at the same time?

9 Answers  

---

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

0 Answers  

---

Explain the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

How to create stored procedures with parameters in ms sql server?

0 Answers  

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---

Do you know the cursor optimization tips?

0 Answers  

---

How to provide values to user defined function parameters?

0 Answers  

---