Answer Posted / dilipkumar

there are 1 clustered index and...
in 2008 sql server total 249 non clustered index
in 2010 sql server total 999 non clustered index
in 2012 sql server total 999 non clustered index.

Describe how to use linked server?

1025

---

How do you debug a procedure in sql server?

956

---

What does select 1 mean?

937

---

How to select some specific columns from a table in a query in ms sql server?

1006

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2228

---

What do you mean by stored techniques? How would we use it?

1041

---

what are the important architecture components of SSRS?

140

---

Do you know what are acid properties of transaction?

962

---

What are joins in sql and what are the different types of joins?

1016

---

Where in ms sql server is ’100’ equal to ‘0’?

1094

---

Is the log file is a part of file group?

1041

---

Explain contrast amongst grouped and non-bunched records?

1031

---

What is the contrast between sql and mysql?

1113

---

Does any body please help me what question's have asked for SSRS in the interview?

2151

---

What is 4nf in normalization form?

1031

---