SQL Server Database Engine
Any questions or discussions relating to the SQL Server Database Engine, performance, features, Full-text Search, linked servers, etc.
Announcements
SQL Server 2008 SP1 released
Ed LehmanMSFTWednesday, April 08, 2009 6:18 PMService 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.
- 585

Creating a Linked Server with 64 bit SQL Server 2008 to MS Access
pcrtx Tuesday, November 24, 2009 4:07 AM - 147

MSDN Virtual Lab
A NEW SQL DBA 3 hours 48 minutes ago - 138

Are SQL Server Deadlocks Possible Without Transactions?
Jeff Roughgarden 7 hours 35 minutes ago - 1374

standard view with multiple inner joins. selecting a single column what happens in the background?
Caos225 11 hours 13 minutes ago - 244

Keys disappearing
pateramj 9 hours 21 minutes ago - 134

Database FAIL: transaction log maxed out.
draymond 9 hours 3 minutes ago - 6173

Error message on SQL counters (Event ID 1021)
Arend van Nierop Thursday, November 19, 2009 4:27 AM - 039

sys.dm_db_index_physical_stats execution time
Ola Hallengren 9 hours 41 minutes ago - 260

Warning: SQL cache memory usage: %d (pages)
MartinGleeson 20 hours 54 minutes ago - 8130

Sometime sql server locks down/freezes
Mike9990 Saturday, November 21, 2009 11:31 AM - 1124712

Does SQL Server Support the "MINUS" Keyword?
TechnoGuy Wednesday, March 22, 2006 11:33 PM - 140

SQLServer blocking
Wison Ho 13 hours 29 minutes ago - 4103

Robo Copy command to transfer sql server logshipping files
Naga1982 Tuesday, November 24, 2009 3:45 PM - 12125

BUG on SQL Server 2008 with Unique Index
José Guimarães Tuesday, November 24, 2009 1:30 PM - 257

Limit access from allowed clients
Fabri_Fabri 21 hours 3 minutes ago - 253

Got an error when I tried to implement WMI and the deadlock graph
LuisGranados Tuesday, November 24, 2009 11:41 PM - 870

Able to login with MgrConsole, Same credentials Linked server not working
Harry Leboeuf Kinepolis 23 hours 50 minutes ago - 460

Not able to connect on Windows 7
Vinodonly 22 hours 21 minutes ago - 345

Error when trying to open properties of tempdb or model databases sql server 2005
collie12 20 hours 6 minutes ago - 158

Shrink database?
Nikesh Kootan Wednesday, November 25, 2009 7:40 AM

