How to locate and take substrings with charindex() and substring() functions?

0 Answers  

---

How to find related tables in sql server?

0 Answers  

---

Describe about first three Normal forms.

1 Answers   HP,

---

How many columns can exist together per table?

0 Answers   Cap Gemini,

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

---

---

What is a partition key?

0 Answers  

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

What is transact-sql ddl trigger?

0 Answers  

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

---

Does partitioning help performance?

0 Answers  

---

How to find tables without indexes?

0 Answers  

---