Answer Posted / somu

We can create total 250 indexes per table . i,e 1 Clustered
Index and 249 Non Clustered Indexes

What is the standby server?

908

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1162

---

How do you check sql server is up and running?

933

---

How to edit table in sql server 2017?

880

---

What are the restrictions applicable while creating views? : SQL Server Architecture

979

---

Do you know what are the ways available in sql server to execute sql statements?

962

---

Does sql server use t sql?

955

---

Explain use of expression builder.

949

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

840

---

How to recreate an existing index in ms sql server?

985

---

What is change data capture (cdc) in sql server 2008?

979

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

900

---

What are trace flags and mention a few common trace flags used with sql server?

1036

---

When you use @@error and try-catch?

983

---

What is the difference between a check constraint and a rule?

1131

---