SQL Server - Does a SQL Server cluster support load 
											balancing? - Feb 27, 2010 at 11:50 AM by Shuchi Gauri 
								Does a SQL Server cluster support load balancing? Explain
								SQL Server cluster does not natively support load balancing. Cluster has only 
									one purpose and that is of boosting fault tolerance of the database. When a 
									cluster fails, instance of SQL Server running on the failed server is simply 
									moved to another server which then catches up with the load. 
								SQL Server - Does a SQL Server cluster support load 
											balancing? - May 05, 2009 at 22:00 PM by Rajmeet Ghai 
								Does a SQL Server cluster support load balancing? Explain
								
								
									SQL server cluster does not support load balancing. In clustering, fault 
									tolerance of a server is increased. When this cluster fails, another instance 
									of this server takes over.
								 
								SQL Server - Does a SQL Server cluster support load 
											balancing? - June 21, 2009 at 09:00 AM by Amit Satpute 
								No. SQL Server doesn’t support load balancing. 
								Clustering is used to boost fault tolerance. 
									When a cluster fails over, the SQL Server instance running on the failed server 
									is shifted to another server. 
									If the other server has an instance running on it, it will now have two 
									instances running. 
								
									  
								
								
								
								
								Also read 
								
								Answer - Database users can have permission to execute a stored 
									procedure without being.... 
								
								Answer - A batch is a group of one or more SQL statements. SQL 
									Server compiles the statements...... 
								
								Answer - Database users can have permission to execute a stored 
									procedure without being......
								 
								
								DBCC DBREINDEX is an offline operation is used to rebuild the indexes of a table 
									dynamically............. 
								
								The only way to alter a User Defined Data Type is to drop the existing and 
									create a new one..........
									 
								
							 |