Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Shared Scalable Databases Expand / Collapse
Author
Message
Posted Thursday, January 8, 2009 12:06 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 10:36 AM
Points: 31,362, Visits: 15,823
Comments posted to this topic are about the item Shared Scalable Databases






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #632144
Posted Thursday, January 8, 2009 12:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:57 AM
Points: 2,480, Visits: 3,021
From the MSDN site http://msdn.microsoft.com/en-us/library/ms345392.aspx I read the following:
An identical view of reporting data from all servers.
This assumes that all of the server instances are configured identically, for example, that they use a single collation.


From the word ASSUMES I conclude that it is possible to use different collations on the server instances. Okay, the results will vary between the server instances, but that wasn't the question...


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #632148
Posted Thursday, January 8, 2009 7:39 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 7:42 AM
Points: 3,688, Visits: 72,435
HanShi (1/8/2009)


From the word ASSUMES I conclude that it is possible to use different collations on the server instances. Okay, the results will vary between the server instances, but that wasn't the question...


I wouldn't call getting different results from each server due to collation differences a benefit under any circumstances.




--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #632383
Posted Thursday, January 8, 2009 8:06 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, December 15, 2014 10:28 AM
Points: 1,544, Visits: 2,274
Has anyone used shared scalable databases? It's something I've been mildly considering on and off.

The Redneck DBA
Post #632421
Posted Tuesday, February 24, 2009 3:32 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 13, 2014 2:52 PM
Points: 3,428, Visits: 14,451
This assumes that all of the server instances are configured identically, for example, that they use a single collation.

This is something I know because SQL Server uses UCS-2 when it assumes the same collation there must be reasons that one collation must be used because SSRS comes without localization.


Kind regards,
Gift Peddie
Post #663879
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse