InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 10:34:25 GMT20http://www.sqlservercentral.com/Forums/Topic1106649-1357-1.aspx[quote][b]tgarland (5/11/2011)[/b][hr]Is there any possibility with having different collations across the databases that you could run into issues when running queries that cross databases especially involving joins? What about any issues with TempDB if the collations are different? Thanks.[/quote]I ran into this recently when I created a table with database defaults to test something, joined with an existing table, and had collation issues. Very annoying, but it's something that we have documented and have to deal with.Wed, 11 May 2011 14:44:12 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1106649-1357-1.aspx[quote][b]jcrawf02 (5/11/2011)[/b][hr]Brad, re: the 8 TempDB files, I have no direct info here, but yesterday's SSC newsletter had a link to a blog by Eric Stephani ([url=http://ericstephani.com/?p=166]http://ericstephani.com/?p=166[/url]) where he was recapping the SQL Skills immersion training, and he mentions multiple data files with a "sweet spot" around 8. I'm sure Paul/Kim could provide much more info about that.[/quote]I also attended the same training from Paul and Kim. Generally speaking, they are recommending using a number of files equal to 1/4 to 1/2 of the number of cores, with 8 being the maximum. I will follow this article with a single article discussing this exact topic.Wed, 11 May 2011 08:35:21 GMTbradmcgehee@hotmail.comhttp://www.sqlservercentral.com/Forums/Topic1106649-1357-1.aspx[quote][b]tgarland (5/11/2011)[/b][hr]Is there any possibility with having different collations across the databases that you could run into issues when running queries that cross databases especially involving joins? What about any issues with TempDB if the collations are different? Thanks.[/quote]Good point. As far as I can tell, there are no cross database queries running, although I will ask the developer about this and find out.Wed, 11 May 2011 08:32:52 GMTbradmcgehee@hotmail.comhttp://www.sqlservercentral.com/Forums/Topic1106649-1357-1.aspxBrad, re: the 8 TempDB files, I have no direct info here, but yesterday's SSC newsletter had a link to a blog by Eric Stephani ([url=http://ericstephani.com/?p=166]http://ericstephani.com/?p=166[/url]) where he was recapping the SQL Skills immersion training, and he mentions multiple data files with a "sweet spot" around 8. I'm sure Paul/Kim could provide much more info about that.Wed, 11 May 2011 08:28:13 GMTjcrawf02http://www.sqlservercentral.com/Forums/Topic1106649-1357-1.aspxIs there any possibility with having different collations across the databases that you could run into issues when running queries that cross databases especially involving joins? What about any issues with TempDB if the collations are different? Thanks.Wed, 11 May 2011 08:06:04 GMTtgarlandhttp://www.sqlservercentral.com/Forums/Topic1106649-1357-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/ssc+clinic/73532/">SQLServerCentral Best Practices Clinic: Part 3</A>[/B]Wed, 11 May 2011 00:01:21 GMTbradmcgehee@hotmail.com