Can any one say what are the Do's and Don't for Sql server 2005 standard edition

Question

Can any one say what are the Do's and Don't for Sql server 2005 standard edition

naga.rohitkumar

SSCertifiable

Points: 5738
More actions
September 18, 2014 at 10:14 pm

#296569

Hi all,
Can any one say what are the Do's and Don't for Sql server 2005 standard edition breifly
Thanks
Naga.Rohitkumar

Viewing 5 posts - 1 through 4 (of 4 total)

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

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 1

naga.rohitkumar (9/18/2014)
Hi all,
Can any one say what are the Do's and Don't for Sql server 2005 standard edition breifly

Not certain what you are indeed asking but a short list would be:

Do's: Upgrade to SQL Server 2012/2014

Don't: Not upgrade SQL Server 2012/2014

😎

naga.rohitkumar SSCertifiable Points: 5738 More actions · Answer 2

Hi ,

I just wann to know what are all the things we should do in standard editon of sqlserver 2005 in our environment most of the servers in Standard Editons I had Experinrce previously with Enterprise Editons only so can you please guide me in this

Thanks

Naga.RohitKumar

Thanks
Naga.Rohitkumar

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 3

Taka a look at this - http://technet.microsoft.com/en-us/library/ms143761(v=sql.90).aspx

Igor Micev,My blog: www.igormicev.com

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

Your question is so incredibly vague there is no real way to answer it. Do things that make your code accurate and fast. Don't do things that make your code inaccurate or slow. This is really a list for ANY version but maybe you see the point.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/