Any SQL Server 2008 R2 Best Practices Documents

Question

Post reply

Any SQL Server 2008 R2 Best Practices Documents

JC-3113

SSCrazy Eights

Points: 8371
More actions
May 6, 2011 at 9:49 am

#250398

Hi Folks
Does anyone know of any SQL Server 2008 R2 Best Practices Documents
I only found this blog here
SQL Aloha - SQL Server 2008 R2 Best Practices Analyzer
Thanks
Jim

Viewing 9 posts - 1 through 8 (of 8 total)

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

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

You may want to examine the URL's listed below:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591

http://sqlblog.com/blogs/davide_mauri/archive/2010/06/21/installing-sql-server-2008-r2-best-practices-analyzer-on-a-stand-alone-machine.aspx

http://blogs.msdn.com/b/psssql/archive/2010/06/20/introducing-the-sql-server-2008-r2-best-practices-analyzer-bpa.aspx

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

JC-3113 SSCrazy Eights Points: 8371 More actions · Answer 2

So there are no "Best Practices" documents out there?

Just this Analyzer ?

Thanks

Jim

Lowell SSC Guru Points: 323504 More actions · Answer 3

Most best practices for previous version of SQL are still valid, of course, so don't limit your searches jsut to 2008 R2.

there's several series of articles here on SSC for Best Practices and Worst Practices; great reading, especially the "Worst Practices" I think. knowing what is a bad practice steers you just as well, or better, than recommendations for good practice.

http://www.sqlservercentral.com/search/?q=best+practices&t=a

http://www.sqlservercentral.com/search/?q=worst+practices&t=a

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 4

JC-3113 (5/6/2011)
So there are no "Best Practices" documents out there?
Just this Analyzer ?
Thanks
Jim

What best practices are you looking for? SQL Server is so wide, with so many features, it's hard to say write a best practices document outside of a narrow area.

There are some recommendations, but the applications are so varied that I don't know a lot of people that write best practices with confidence. The SQL CAT team has some great recommendation practices in specific areas you can browse here: http://sqlcat.com/Default.aspx

JC-3113 SSCrazy Eights Points: 8371 More actions · Answer 5

JC-3113

SSCrazy Eights

Points: 8371

May 6, 2011 at 12:42 pm

#1321227

Thanks Lowell

Jim

JC-3113 SSCrazy Eights Points: 8371 More actions · Answer 6

Thanks Steve

when I installed sql server 2005 there were a few documents I was able to locate

same for 2008, which mostly used sql server 2005

windows 2008 r2 running sql server 2008 r2 seem to be different

just wondering if there was anything new that i need to know for 2008 r2

Jim

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 7

I'm not sure there's something you "need" to know about R2. There are more features, PBM is enhanced, filestream, etc. that are changed a bit, but I'm not sure there are better Best Practices right now for R2.

JC-3113 SSCrazy Eights Points: 8371 More actions · Answer 8

JC-3113

SSCrazy Eights

Points: 8371

May 9, 2011 at 9:37 am

#1321789

Okay

Thanks Steve

Jim