what is node in sql server?
Answers were Sorted based on User's Feedback
Answer / mamatha
A SQL Server 2005 cluster includes two or more physical
servers (called nodes) identically configured. One node is
designated as the active node where a SQL Server 2005
instance is running in production, and the other node is an
inactive node where SQL Server is installed, but not
running. Should the SQL Server 2005 instance on the active
node fail, the inactive node will become the active node and
continue SQL Server 2005 production with minimal downtime.
Is This Answer Correct ? | 37 Yes | 6 No |
Answer / sumit
A SQL Server 2005 cluster includes two or more physical
servers (called nodes) identically configured. One node is
designated as the active node where a SQL Server 2005
instance is running in production, and the other node is an
inactive node where SQL Server is installed, but not
running. Should the SQL Server 2005 instance on the active
node fail, the inactive node will become the active node and
continue SQL Server 2005 production with minimal downtime
Is This Answer Correct ? | 18 Yes | 5 No |
you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
how to get the automatic backup of the database in the sql server
Do you know what is sql service broker?
What is the difference between having and where clause?
How is table type constraint applied to a table?
What is an execution plan? When would you use it? How would you view the execution plan?
can foreign key take role of primary key?
5 Answers CarrizalSoft Technologies, TCS, Villa Marie,
Explain the use of containers in ssis?
what is the difference between group and having give an example with query and sample output
Describe in brief system database.
Explain what are the restrictions that views have to follow? : SQL Server Architecture