Shared Scalable Databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » Shared Scalable Databases

Shared Scalable Databases

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Thursday, January 08, 2009 12:06 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 9:03 PM
Points: 31,406, Visits: 13,723

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

HanShi

Posted Thursday, January 08, 2009 12:20 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 7:30 AM
Points: 1,114, Visits: 1,140

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

mtassin

Posted Thursday, January 08, 2009 7:39 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 2:37 AM
Points: 3,226, Visits: 64,106

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

Jason Shadonix

Posted Thursday, January 08, 2009 8:06 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:27 AM
Points: 1,407, Visits: 2,020

Has anyone used shared scalable databases? It's something I've been mildly considering on and off.

Jason Shadonix
MCTS, SQL 2005

Post #632421

Gift Peddie

Posted Tuesday, February 24, 2009 3:32 PM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 29, 2013 11:17 AM
Points: 3,432, Visits: 14,332

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 »

Permissions