Shared Scalable Databases

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

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

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

    The Redneck DBA

  • 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