Answer / Vivek Chaoudhary

"Dynamic Management Views (DMVs)": DMVs are a collection of SQL Server views that provide extensive, programmable introspection into the internals of the database engine. They allow developers and DBAs to monitor and troubleshoot performance issues and manage their databases more effectively."

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

1 Answers  

---

What is an identity?

1 Answers  

---

What is equi join with example?

1 Answers  

---

Define normalisation?

1 Answers  

---

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

---

What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,

---

Define Unique Key?

1 Answers   HCL,

---

What is failover clustering overview?

1 Answers  

---

What is built-in/administrator?

1 Answers  

---

Do you know what guidelines should be followed to help minimize deadlocks?

1 Answers  

---

how to do partition in sqlserver

1 Answers   TCS,

---

What is the template in sql?

1 Answers  

---