July 2009 – Technical Rollup Mail – SQL Server
News
Microsoft Releases SQL Server 2008 Service Pack 1
Microsoft has released SQL Server 2008 Service Pack 1 with enhancements meant to ease deployment but no brand new features.
https://www.eweek.com/c/a/Database/Microsoft-Releases-SQL-Server-2008-Service-Pack-1-687774/
SQL Server to Get Real-Time Boost
The next release of Microsoft's SQL Server database, code-named "Kilimanjaro," will offer master data management (MDM) and support real-time data feeds for business intelligence (BI), reporting and analytics, the company revealed today.
https://reddevnews.com/news/article.aspx?editorialsid=10836%20
Microsoft Announces SQL Server Fast Track Data Warehouse
New reference architectures from Bull, Dell and HP make it faster, easier, and more affordable for companies to deploy enterprise-class data warehousing projects.
https://www.microsoft.com/presspass/press/2009/feb09/02-23SQLFastTrackPR.mspx
Dave Campbell on SQL Server 2008, Cloud Services, and More
What he thinks about the latest SQL Server release, Kilimanjaro, Madison, and Azure.
https://www.sqlmag.com/Articles/ArticleID/101093/101093.html?Ad=1
Reduce IT Spending While Still Upgrading to SQL Server 2008
The latest features and functionality included out-of-the-box with SQL Server 2008 will allow IT managers to save a tremendous amount of money and at the same time reduce management costs, hence it is worth the investment and you should upgrade to SQL Server 2008.
https://www.networkworld.com/community/node/37293
Other
Technical RollUp
https://blogs.technet.com/trm/default.aspx
Downloads
SQL 2005
Partial Database Availability
SQL Server 2005 features that enable appropriately designed solutions to achieve partial availability and remain online even after a disk subsystem hardware failure.
SQL 2008
Partial Database Availability
SQL Server 2005 features that enable appropriately designed solutions to achieve partial availability and remain online even after a disk subsystem hardware failure.
Events/Webcasts
TechNet Webcast: How Microsoft IT Manages Vendor Development Projects (Level 300)
Tuesday, July 28, 2009 9:30 AM Pacific Time (US & Canada)
When managing vendor development projects, lack of metrics, or the dependence on a single metric, can lead to surprises by the project’s end. Learn about the tracking system that Microsoft IT uses to manage software development projects from a client perspective. Agile Cross IT Engineering (AXE) generates telling project metrics from a small amount of provided data. The system provides immediate project feedback, and supports overall project and vendor analysis.
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032417615&culture=en-US
New KB's
Other
SQL Svr Compact Edtn 3.5 AL: FIX: Access violations occur when you run an application under heavy load conditions after you install the 64-bit version SQL Server Compact 3.5 Service Pack 1
https://support.microsoft.com/kb/970269/EN-US
SQL Svr Compact Edtn 3.5 AL: FIX: Initial synchronization of a replication to SQL Server Compact 3.5 subscribers takes significant time to finish
https://support.microsoft.com/kb/970414/EN-US
SQL 2000
SQL Svr 64-bit 2000 EN: FIX: An access violation occurs when you run a DELETE statement or an UPDATE statement in the Itanium-based versions of SQL Server 2000 after you install security update MS09-004
https://support.microsoft.com/kb/971524/EN-US
SQL 2005
SQL Svr 2005 Analysis Svcs EN: FIX: Measures, measure groups, and dimensions that are not part of a perspective are exposed incorrectly when you create a grouping on the perspective in SQL Server 2005 Analysis Services or in SQL Server 2008 Analysis Services (Updated)
https://support.microsoft.com/kb/968900/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: Error message when you run an MDX query that requests a dimension property on a parent-child hierarchy in Microsoft SQL Server 2005 Analysis Services
https://support.microsoft.com/kb/970551/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: An MDX query that uses the NON EMPTY clause and the DrillDownLevel function returns null values in SQL Server 2005 Analysis Services
https://support.microsoft.com/kb/970966/EN-US
SQL Svr 2005 Reporting Svcs EN: How to install a 32-bit version of SQL Server 2005 Reporting Services on a computer that is running a 64-bit version of Windows (Updated)
https://support.microsoft.com/kb/934162/EN-US
SQL Svr 2005 Reporting Svcs EN: How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server 2008 (Updated)
https://support.microsoft.com/kb/938245/EN-US
SQL Svr 2005 Reporting Svcs EN: FIX: Error message when you open a report by specifying multiple values for a multivalued parameter in a URL in SQL Server 2005 Reporting Services: "Default value or value provided for the report parameter '<Parameter>' is not a valid value" (Updated)
https://support.microsoft.com/kb/970058/EN-US
SQL Svr 2005 Reporting Svcs EN: Error message when you view a report from Report Manager, ReportViewer, or a SharePoint site: "Execution '<SessionID>' cannot be found (rsExecutionNotFound)"
https://support.microsoft.com/kb/972328/EN-US
SQL Svr Standard Edtn 2005 EN: The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released (Updated)
https://support.microsoft.com/kb/937137/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: When you run a query against a table that contains Traditional Chinese characters, the incorrect result is returned in SQL Server 2005 (Updated)
https://support.microsoft.com/kb/948567/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Data results are inconsistent when you run a search query that uses the NEAR operator against an XML type data that contains the xml:lang attribute (Updated)
https://support.microsoft.com/kb/956574/EN-US
SQL Svr Standard Edtn 2005 EN: The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released (Updated)
https://support.microsoft.com/kb/960598/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: When you run a query that has a parallel execution plan in parallel under the READ COMMITTED isolation level on a database that is set the READ COMMITTED SNAPSHOT option in SQL Server 2005, the query that you may obtain may return uncommitted data (Updated)
https://support.microsoft.com/kb/961050/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The SQL Server service stops responding, and you receive error 1450 when you create database snapshot or run a DBCC CHECK statement on a database in SQL Server 2005 and in SQL Server 2008 (Updated)
https://support.microsoft.com/kb/967164/EN-US
SQL Svr Standard Edtn 2005 EN: Cumulative update package 3 for SQL Server 2005 Service Pack 3 (Updated)
https://support.microsoft.com/kb/967909/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you send an e-mail by using Database Mail in SQL Server 2005 or in SQL Server 2008: "The operation has timed out" (Updated)
https://support.microsoft.com/kb/968834/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: An assertion failure occurs when you switch the schedule of a report subscription between a shared schedule and a custom schedule in SQL Server 2005 Report Services
https://support.microsoft.com/kb/969528/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: You receive inconsistent results when you run index-related DMVs to return statistical information about missing indexes in SQL Server 2005 (Updated)
https://support.microsoft.com/kb/969844/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you run a SQL Server 2005 or SQL Server 2008 Integration Services package (SSIS) after you install the .NET Framework 2.0 SP2 or the .NET Framework 3.5 SP1: "ADO NET Source [1424]"
https://support.microsoft.com/kb/969845/EN-US
SQL Svr Standard Edtn 2005 EN: Cumulative update package 14 for SQL Server 2005 Service Pack 2
https://support.microsoft.com/kb/970278/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The SQL Server service consumes lots of memory when you run a query that uses the sys.dm_exec_sql_text dynamic management function in the APPLY operator in SQL Server 2005
https://support.microsoft.com/kb/970648/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message in the Errorlog file when you run a query in SQL Server 2005: "A time-out occurred while waiting for buffer latch" (Updated)
https://support.microsoft.com/kb/970672/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: CPU usage increases when you run a query that uses a string comparison function on a computer that has many processors after you upgrade to SQL Server 2005 Service Pack 3 (Updated)
https://support.microsoft.com/kb/970823/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you run a report in SQL Server 2005 SP2 Reporting Services by using a URL from a subscription: "Object reference not set to an instance of an object."
https://support.microsoft.com/kb/971114/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you send an e-mail by using a private Database Mail profile in SQL Server 2005: "profile name is not valid"
https://support.microsoft.com/kb/971402/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you run a query that contains duplicate join conditions in SQL Server 2005: "Internal Query Processor Error: The query processor could not produce a query plan"
https://support.microsoft.com/kb/971409/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: An UPDATE or a DELETE statement that uses a join on a remote table in a linked server runs very slowly in Microsoft SQL Server 2005
https://support.microsoft.com/kb/971529/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The synchronization operation fails when you run the Merge Agent to synchronize a merge publication that uses Web synchronization in SQL Server 2005
https://support.microsoft.com/kb/971607/EN-US
SQL Svr Std Edtn 2005 64Bit EN: The "SQL Server:SSIS Pipeline" performance object does not appear in the "Performance object" list after you install Integration Services from a 64-bit version of SQL Server 2005 (Updated)
https://support.microsoft.com/kb/941154/EN-US
SQL 2008
SQL Svr Enterprise 2008 EN: How to update or slipstream an installation of SQL Server 2008 (Updated)
https://support.microsoft.com/kb/955392/EN-US
SQL Svr Enterprise 2008 EN: List of known issues when you install SQL Server on Windows 7 RC or on Windows Server 2008 R2 RC (Updated)
https://support.microsoft.com/kb/955725/EN-US
SQL Svr Enterprise 2008 EN: Error message when you try to batch insert data on a publisher of a merge replication in SQL Server 2008 or SQL Server 2005: "Msg 548, Level 16, State 2, Line 1. The insert failed"
https://support.microsoft.com/kb/972006/EN-US
SQL Svr Enterprise 2008 EN: SQL Server Failover Cluster Instance is taken offline when you change the password for the service account on the non-owner node
https://support.microsoft.com/kb/972387/EN-US
SQL Svr Standard 2008 EN: The ActiveX Script task in an Integration Services package does not run after you uninstall SQL Server 2005 from a computer that has SQL Server 2008 installed (Updated)
https://support.microsoft.com/kb/955713/EN-US
SQL Svr Standard 2008 EN: FIX: A time-out occurs when you use SQL Server Management Studio to try to restore a large database from a backup on a tape in SQL Server 2008 (Updated)
https://support.microsoft.com/kb/967205/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you perform an update or a delete operation on a table that does not have a clustered index created in SQL Server 2005 and in SQL Server 2008: "The operating system returned error 1450" (Updated)
https://support.microsoft.com/kb/967470/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you run a job whose owner is a Windows user account after SQL Server 2005 Agent or SQL Server 2008 Agent is restarted: "The job failed. The owner () of job <Job Name> does not have server access" (Updated)
https://support.microsoft.com/kb/969611/EN-US
SQL Svr Standard 2008 EN: Stop error message when you install SQL Server 2005 Service Pack 3 or SQL Server 2008 on a Windows XP-based computer that is earlier than Windows XP SP3: "CRITICAL_OBJECT_TERMINATION" (Updated)
https://support.microsoft.com/kb/969936/EN-US
SQL Svr Standard 2008 EN: FIX: You receive an incorrect result when you query data from a linked server that is created by using an index OLE DB provider in SQL Server 2005 or in SQL Server 2008 (Updated)
https://support.microsoft.com/kb/969997/EN-US
SQL Svr Standard 2008 EN: FIX: Queries from a query notification that has a lot of subscriptions run slowly when you change the Auto Close option to False in SQL Server 2005 or in SQL Server 2008 (Updated)