Post reply

Shared Scalable Databases

  • January 8, 2009 at 12:06 am

    #383700

    Comments posted to this topic are about the item Shared Scalable Databases

  • January 8, 2009 at 12:20 am

    #923118

    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’! **

  • January 8, 2009 at 7:39 am

    #923316

    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[/url]
    For tips on how to post your problems[/url]

  • January 8, 2009 at 8:06 am

    #923349

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

    The Redneck DBA

  • February 24, 2009 at 3:32 pm

    #949679

    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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply