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 |
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
Explain a join?
What are the steps to process a single select statement?
Define self join in sql server joins?
What is in place upgrade in sql server?
What is Primary key and foreign key? Give an example
Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).
What are unicode character string data types in ms sql server?
Can we execute a stored procedure inside a trigger?
6 Answers BirlaSoft, CarrizalSoft Technologies, United Healthcare,
there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
What is partitioned view?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)