SQL Server Database Engine
Any questions or discussions relating to the SQL Server Database Engine, performance, features, Full-text Search, linked servers, etc.
Announcements
- Link
SQL Server 2008 SP1 released
Service Pack 1 for SQL Server 2008 is now available for customers. The Service pack is available via download at http://www.microsoft.com/downloads/en/default.aspx and is primarily a roll-up of previous cumulative updates, quick fix engineering updates and minor fixes made in response to requests reported through the SQL Server community. While there are no new features in this service pack, customers running SQL Server 2008 should download and install SP1 to take advantage of the fixes which increase supportability and stability of SQL Server 2008.
Customers have no reason to wait to upgrade to SQL Server 2008 and many are already taking advantage of SQL Server 2008 as a smart IT investment. In fact, there have been over 3 million downloads of SQL Server 2008 since the RTM in August. With this Service pack, Microsoft is introducing 80% fewer changes to customer configurations compared to previous SQL Server Service Pack releases. This remarkable decrease is a testament to a revised product development process and updated servicing strategy that is focused on ease of deployment while keeping customer environments stable.
With this service pack, Microsoft has made investments to ease deployment and make management of service packs more efficient. Key improvements in SP1 include Slipstream, Service Pack Uninstall and Report Builder 2.0 click-once deployment.
· Slipstream allows administrators to install SQL Server 2008 and Service Pack 1 in a single instance. This decreases the total time for an installation, including a fewer number of reboots thereby increasing productivity and deployment availability.
· Service Pack Uninstall allows administrators to uninstall the service pack separately from the database release. This feature also improves DBA productivity, reduces the cost of deployment and improves overall supportability
· Report Builder 2.0 Click Once improves the existing SQL Server end-user report authoring application by easing deployment to business users
To download the SQL Server 2008 Service Pack 1, please click here.
For more information on SQL Server 2008, please click here.
Filtering and SortingUse these options to narrow down the question and discussion list.
- 338

how to find missing tabel in sql server express edition
Ganapathi Varma CH 4 hours 32 minutes ago - 18149

Protecting an RDBMS System from DBA-s
Kalman TothMicrosoft Community ContributorFriday, May 17, 2013 10:31 AM - 151

How to Check the Sql Server license(MSDN copy or Production Version)
Kevin Lan 11 hours 15 minutes ago - 594

SQL 2008 R2 - more physical memory than database size
kungpow112 Saturday, May 18, 2013 9:39 AM - 270

Drop Application role
sourises Saturday, May 18, 2013 10:55 AM - 277

How to configure a computed column that uses two related tables at table design time
PaulAnthonySamson Friday, May 17, 2013 11:14 PM - 381

select list because it is not contained in either an aggregate function or the GROUP BY clause.
Ravuri777 Saturday, May 18, 2013 9:38 AM - 4105

SQL Server 2012 - Data Collector - Server Activity & Query Statistics Reports Have No Data
Tom Molskow Friday, May 17, 2013 2:24 AM - 11232

xp_delete_file extremely slow on a server - Wait_Info PREEMPTIVE_OS_GETPROCADDRESS
Ola Hallengren Wednesday, May 08, 2013 5:39 PM - 12115

Log database always full
Dhow Friday, May 17, 2013 1:38 PM - 1133

Recommendation about DBA role
MSSQLBIDWH Friday, May 17, 2013 2:01 PM - 2103

Instance error
Phemo01 Thursday, May 16, 2013 5:49 AM - 5146

SQL Server 2008 Memory Usage details
skan2dan Wednesday, May 15, 2013 3:41 PM - 284

How to assign AD group default schema
DBA_LEARNER Friday, May 17, 2013 9:56 PM - 167

can ODBC bcp_writefmt create a format file from the source table?
w_bentley Friday, May 17, 2013 3:47 PM - 7155

SQL Server 2012 Shutting Down Randomly
CameronMc85 Friday, May 17, 2013 2:52 PM - 8112

Random Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server.
Gus Jones Wednesday, May 15, 2013 8:15 PM - 9150

Can be stored procedures without cache?
Vithor da Silva e Silva Tuesday, May 14, 2013 2:23 PM - 14163

SQL Compression performance issue
Ishfaq Ahmed Wednesday, May 15, 2013 3:53 PM - 11238

Could not allocate a new page for database 'XXXX' because of insufficient disk space in filegroup 'PRIMARY'.
HYDBA Thursday, May 09, 2013 5:03 AM

