SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2005 Best Practices


SQL Server 2005 Best Practices

Author
Message
Sports Nut
Sports Nut
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 227

I would agree with the other comments, nice article but hardly best practice. One thing that was not mentioned was the use of the Upgrade Advisor, which comes with SQL Server 2005. I would highly recommend this prior to making an migration moves whatsoever as it provides you with a comprehensive list of tasks to be performed prior to migration, and once migrated setting the compatibility level to 90.

For those looking for a resource on Partitioning in SQL 2005 Kimberly Tripp has a good paper on it. http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm

I agree with Chris H regarding the use of CLR. While I have not enabled it as yet I am certain that someone will present me with a strong enough business case where I will need to enable CLR in SQL. I have not come to grips with a process for allowing developers to deploy, but one thing is for certain no code will be deployed until I have looked at the code and bless it.

Microsoft is deprecating many commands as we know them today in SQL 2000 for better or for worse. Again running the Upgrade Advisor will assist greatly in the task of mitigating these issue.

John


currym
currym
SSC-Enthusiastic
SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)SSC-Enthusiastic (123 reputation)

Group: General Forum Members
Points: 123 Visits: 57
Good review of new features.



Jim Dillon-291542
Jim Dillon-291542
SSC-Addicted
SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)

Group: General Forum Members
Points: 468 Visits: 176
Is there a "real" best practices guide for SQl Server 2005? If so, google can't find it. Does a best practices guide really exist? This article is definitely not a best practices guide.
DCPeterson
DCPeterson
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2065 Visits: 432

It's not exactly a "best practices" guide but here is the link to the msdn operations guide (as it currently exists) for SQL Server 2005

http://www.microsoft.com/technet/prodtechnol/sql/2005/library/operations.mspx



/*****************

If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek



*****************/
Jim Dillon-291542
Jim Dillon-291542
SSC-Addicted
SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)

Group: General Forum Members
Points: 468 Visits: 176
Thanks for the link. It should help me get started. However, I don't understand how a company can "roll out" a new product without guides on how to use it properly. Thanks for the help DC Peterson, it's much appreciated.
DCPeterson
DCPeterson
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2065 Visits: 432
They have actually done a really good job with Books Online from my experience, and there are certainly a bunch of specific recommendations there, but it's not in an easily readable "white paper" format.

/*****************

If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek



*****************/
HelicoLift
HelicoLift
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 46
Is it OK to install SQl Server 2005 final on my laptop?

Our current production environment is VS.NET 2003 and SQL Server 2000. I would like to install SS2005 to play around. Would that impact previous dev tools?

Thanks in advance.
Yelena Varshal
Yelena Varshal
SSCertifiable
SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)

Group: General Forum Members
Points: 5546 Visits: 597

I agree with others that this is a nice list of the new features but not Best Practices.

I would not advise to reset Compatibility Level because your current version of your application may use features that are not supported on 2005. The exaple is an industry leader CRM application ( I don't want to name names) where I ran an Upgrade Advisor.

For the Best Practices I would start with ones for developers and ones for sysadmins. Updrades are fine, but what about the new installations? I am still waiting for the best practices for placing features on the drives for 2005. In 2000 I would put Program Files on the OS /Program Files RAID 1 and Data Files on RAID 5. In 2005 when you install, the Data Files feature is a subfeature of Database Engine feature. And I would not put feature and its subfeature on separate drives. This is just an example of what could be a best practice advice.




Regards,
Yelena Varshal

Gary Begin
Gary Begin
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 19
I'd like to hear a response from the author of this article on the DBCC statement.
Alex J
Alex J
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 77
I cant believe I went through the registration process to read this article. Please rename it from 'best practices' to 'upgrade options and new features'.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search