SQL Server 2008 SP1 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server 2008 SP1

Earlier in the week I wrote about the adoption of SQL Server 2008. One of the biggest reasons that often limits the adoption of a Microsoft product is the release of the first service pack. Many companies have a policy that they will not even look at a new release until Service Pack 1 is available. Well the wait is almost over as the Community Technology Preview (CTP) of Service Pack 1 for SQL Server 2008 can be downloaded from here.
It may appear that Service Pack 1 is being released very quickly for SQL Server 2008 especially with the delay between SP2 and SP3 for SQL Server 2005. SQL Server 2005 was released in November 2005 and the first Service Pack was release about five months later in April 2006. Whereas the first Service Pack will be released over seven months after the release of SQL Server 2008. I would be interested in what your thoughts are regarding this. Does this mean that the RTM build of SQL Server 2008 was better than that of 2005?
– Peter Ward

Hello,I have installed a SQL Server 2008 on Windows 2008 Server 64bit. Server has 140GB hard disk and 6GB memory.Windows Server is running on virtual machine (VMware Server)The old Server was Windows 2003 with SQL Express.I note that Windows 2003 + SQL Express is running better than my new server.Any idea? What can I do to make better my new file server?Other question: my database is 4GB file. Can I put entire 4GB file in memory? It´s possible? How can I do it?Thanks
SQL Server 2008 Administration in Action focuses the production DBA, digging deep into the various tasks specific to that role. Expert author Rod Colledge–check him out at sqlCrunch.com–teaches you best practices that cover the lifecycle of a SQL Server system, including infrastructure design, installation, and operational maintenance. And while many of these techniques will work in any recent version of SQL Server, you’ll find full coverage of emerging SQL Server 2008 best practices.good article, i really like it. I am doing a bit on research about SQL Server 2008 SP1 and i found also macrotesting www.macrotesting.com to be very good source. Thanks for you article…..

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |