SQLServerCentral Best Practices Clinic: Part 3

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 Brad M. McGehee » SQLServerCentral Best Practices Clinic: Part...

SQLServerCentral Best Practices Clinic: Part 3

Rate Topic

Display Mode

Topic Options

Author

Message

bradmcgehee@hotmail.com

Posted Wednesday, May 11, 2011 12:01 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:08 PM
Points: 175, Visits: 719

Comments posted to this topic are about the item SQLServerCentral Best Practices Clinic: Part 3

Brad M. McGehee
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.bradmcgehee.com

Post #1106649

tgarland

Posted Wednesday, May 11, 2011 8:06 AM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:33 PM
Points: 1,820, Visits: 1,898

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.

Post #1106972

jcrawf02

Posted Wednesday, May 11, 2011 8:28 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:09 PM
Points: 2,550, Visits: 18,882

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 (http://ericstephani.com/?p=166) 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.

---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Post #1107002

bradmcgehee@hotmail.com

Posted Wednesday, May 11, 2011 8:32 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:08 PM
Points: 175, Visits: 719

tgarland (5/11/2011)

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.

Brad M. McGehee
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.bradmcgehee.com

Post #1107010

bradmcgehee@hotmail.com

Posted Wednesday, May 11, 2011 8:35 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:08 PM
Points: 175, Visits: 719

jcrawf02 (5/11/2011)

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.

Brad M. McGehee
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.bradmcgehee.com

Post #1107015

Steve Jones - SSC Editor

Posted Wednesday, May 11, 2011 2:44 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 2:54 PM
Points: 31,410, Visits: 13,726

tgarland (5/11/2011)

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1107350

« Prev Topic | Next Topic »

Permissions