What are the differences between substr and charindex in sql server.

0 Answers  

---

Explain sql server authentication modes?

0 Answers  

---

Explain the properties of a relational table?

0 Answers  

---

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

---

what is create database syntax? : Sql server database administration

0 Answers  

---

What is a mutating table error and how can you get around it?

0 Answers  

---

What is normalization? Describe its different types.

0 Answers   Wipro,

---

Can I work with several databases simultaneously? : sql server management studio

0 Answers  

---

Define normalisation?

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,

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

0 Answers  

---

When do u use clustered index and non-clustered index?

3 Answers   IBM,

---