Answer / Varun Yadav

On a passive node in a SQL Server Failover Cluster, all services are stopped except for the Clustered Service Minder and the Network Name Resource.

Can group functions be mixed with non-group selection fields in ms sql server?

1 Answers  

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1 Answers  

---

List out different types of normalizations in sql server and explain each of them?

1 Answers  

---

How do I create a stored procedure in sql server?

1 Answers  

---

what is extended StoreProcedure ?

3 Answers   Satyam,

---

What is the default port for SQL Server over a firewall?

1 Answers   Microsoft,

---

How many non clustered indexes there can be on table ?

1 Answers  

---

How can we write or define DDL statements in Sql server and DML statements?

3 Answers  

---

Can foreign key be duplicate?

1 Answers  

---

How ssrs maintain security?

1 Answers  

---

What are the different SQL Server Versions you have worked on?

0 Answers  

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

1 Answers   Verizon,

---