SQL Server Study Material

What is the difference between SQL Server clustering methods: - Active/Active - Active/Passive Active/Active means that both nodes are active and accessing the shared disk resources, but are running independent instances. When a node fails, you need to be sure that the remaining node has the resources available to handle the additional databases that fail over. You can think of it like this. Node A has 1 database on it, and Node B has 1 database on it. Node A goes down, the resources fail over to Node B, and now Node B has 2 databases running on it. In an Active/Passive cluster, you would only have 1 database running on a single node at any given time. Node A is active with 1 DB, Node B is passive with no DBs. Node A goes down, the resources fail over to Node B. Node B is now active with 1 database running on it. I'm sure more experienced cluster admins or SQL admins will savage me for my terminology, but that's it in a nutshell. FAQ: What is the aliv...

  The following Interview questions are categorized as follows 1)    ®   - Real time 2)    (s) - Scenarios 3)    (i) - Important SQL SERVER DBA – TOPIC WISE FAQs INTRODUCTION TO SQL SERVER 2005 1)    What is SQL Server? Microsoft SQL Server 2005 is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data integration, analysis, and reporting solutions. 2)    What is the Versions Available in SQL Server? SQL Server was developed by Microsoft in 1987 and the versions are 6.0, 6.5, 7.0, 8.0(2000), 9.0(2005), 10(2008). 3)    What is the Difference between SQL Server 2000 and 2005? (i)     SQL Server-2000 SQL Server-2005 Can create up to 16 Instances Can create up to 50 instances Query Analyzer and Enterprise Manage...