October 2006 - Technical Rollup Mail - SQL
News
SQL Server 2005 Enterprise Capabilities
Explore various resources to see how SQL Server 2005 can power your enterprise
https://www.microsoft.com/sql/bigdata/default.mspx
Microsoft IT Showcase
Microsoft uses SQL Server to run mission critical applications, increase business intelligence, increase productivity and more. See how here:
https://www.microsoft.com/technet/itsolutions/msit/sql.mspx
SQL Server Customer Advisory Team Blog
Includes entries of best practices and lessons learned from the most demanding SQL Server implementations in the world.
https://blogs.msdn.com/sqlcat/
New Blog from SQL Server Customer Support Team
https://blogs.msdn.com/sqlblog/
Provide suggestions and bug reports on Microsoft SQL Server 2005
Send suggestions and bug reports about the features and user interface of SQL Server 2005, Send suggestions and report inaccuracies about the documentation, Choose to send error reports and feature usage data automatically to Microsoft for analysis.
https://msdn2.microsoft.com/en-us/library/ms166362.aspx
Documents
Physical Database Design
This whitepaper helps database architects and administrators configure Microsoft SQL Server 2005 systems for optimal I/O performance and space utilization. In this whitepaper, you will learn about:
- Internals of SQL Server physical design storage
- Reliability and performance requirements for the database system.
- Deciding upon the hardware to suit the above requirements
- Best practice recommendations for configuring SQL Server to take advantage of the above
- Tracking and monitoring performance on an ongoing basis
https://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx
Working With TempDB in SQL Server 2005
This white paper describes how SQL Server 2005 uses tempdb. Many improvements in SQL Server 2005 optimize tempdb usage and make it easier to manage and to troubleshoot. A case study that uses a workload similar to TPC Benchmark H (TPC-H) shows new ways to manage and troubleshoot tempdb resources. This paper also includes items to consider when upgrading to SQL Server 2005 and configuring tempdb.
https://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx
Downloads
SQL Server 2005 Virtual Backup Device Interface (VDI) Specification
The SQL Server 2005 Virtual Backup Device Interface Specification now contains updated information about the Virtual Backup Device interface. Independent software vendors (ISVs) can use the Virtual Backup Device Application Programming Interface (API) to integrate SQL Server into their products.
SQL Server 2005 Systems View Map
The Microsoft SQL Server 2005 System Views Map shows the key system views included in SQL Server 2005, and the relationships between them.
Events/WebCasts
SQL 2005 Webcasts and Virtual Labs
SQL Server 2005 is data management and analysis software that delivers enhanced security, availability, and scalability to mission-critical data applications—while making them easier to develop, deploy, and manage. Choose from a wide range of live and on-demand webcasts. Or take part in a virtual lab, which allows you to cut your teeth on the new platform by experimenting with its different capabilities.
https://www.microsoft.com/sql/eval/webcast.mspx?wt.mc_id=sql.ad.01037
Free SQL Server 2005 Training
Whether you are interested in database administration, database development, or business intelligence, you can access the E-Learning topic you want, when you want it, and learn at your own pace. Each lesson includes hands-on virtual labs and offline functionality. In addition, you may consider taking a free Microsoft Skills Assessment to help you meet your Microsoft SQL Server 2005 training goals. You'll receive a learning roadmap with additional skills resources including instructor-led classroom training and books.
https://www.microsoftelearning.com/sqlserver2005/default.aspx
Introduction To Data-Aware Windows Mobile Applications
How to create a simple SQL Server Mobile-based Pocket PC application.
https://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20060831MobileRB/manifest.xml
Project Real – Business Intelligence In Practice
Project REAL is a cooperative effort between Microsoft and a number of technology partners in the business intelligence (BI) industry to build on actual customer scenarios to discover best practices for creating BI applications based on SQL Server 2005. The term REAL in Project REAL is an acronym for Reference implementation, End-to-end, At scale, and Lots of users. Listen to members of the Project REAL team through webcasts that target different levels of users.
Further on-demand webcasts are available here: https://www.microsoft.com/events/series/technetsqlserver2005.mspx
New KB’s
SQL Server 2000 Standard Edition
Query performance may decrease when you try to run a query in a parallel plan in SQL Server 2000
https://support.microsoft.com/?kbid=919638
FIX: You may receive an access violation error message when you run a linked server query that includes a subquery
https://support.microsoft.com/?kbid=911569
BUG: You may receive an access violation error message when you try to run an SSIS package in SQL Server 2005
https://support.microsoft.com/?kbid=924016
FIX: In SQL Server 2005, the sp_altermessage stored procedure does not suppress system error messages that are logged in the SQL Server error log and in the Application log
https://support.microsoft.com/?kbid=922578
SQL Server 2000 Enterprise Edition
FIX: You cannot uninstall SQL Server 2000 build 2187 when SQL Server 2000 build 2187 is configured as a Microsoft Cluster Service (MSCS) node
https://support.microsoft.com/?kbid=922040
SQL Server 2000 Analysis Services
FIX: In SQL Server 2000 Analysis Services, a memory leak may occur in the handle thread when you run an MDX query that uses formulas or recursions
https://support.microsoft.com/?kbid=911023
FIX: The connection that processes the cube stops responding, and the cube is locked in SQL Server 2000 Analysis Services
https://support.microsoft.com/?kbid=912468
SQL Server 2005 Standard Edition
BUG: When you click "Build Query" in the "Execute SQL Task Properties" dialog box of the SQL Server 2000 DTS package designer, SQL Server 2005 Management Studio unexpectedly closes
https://support.microsoft.com/?kbid=921929
FIX: A query plan is not cached in SQL Server 2005 when the text of the hint is a large object
https://support.microsoft.com/?kbid=918882
FIX: Log Reader Agent fails, and an assertion error message is logged when you use transactional replication in SQL Server 2005
https://support.microsoft.com/?kbid=923296
Support WebCast: Overview of database mirroring in SQL Server 2005
https://support.microsoft.com/?kbid=925067
Support WebCast: How to use the DataReader Source and the OLE DB Source objects in SQL Server 2005 Integration Services
https://support.microsoft.com/?kbid=925068
Use of detours by a third-party solution is not supported with SQL Server
https://support.microsoft.com/?kbid=920925
You obtain incorrect results when you run a full-text search query that uses a thesaurus file in SQL Server 2005
https://support.microsoft.com/?kbid=923317
FIX: You may receive an access violation error message when you run a query against a linked server in SQL Server 2005
https://support.microsoft.com/?kbid=922296
FIX: An access violation may intermittently occur when you run a SQL Server Integration Services package in SQL Server 2005
https://support.microsoft.com/?kbid=924346
FIX: Error message when you execute an MDX query that calls a VBA function in SQL Server 2005 Service Pack 1: "PFE_ASSEMBLY_NOT_SAFETOPREPARE"
https://support.microsoft.com/?kbid=919956
FIX: When you run a query that references a partitioned table in SQL Server 2005, query performance may decrease
https://support.microsoft.com/?kbid=923849
FIX: You may receive different date values for each row when you use the getdate function within a case statement in SQL Server 2005
https://support.microsoft.com/?kbid=925153
FIX: System performance may be slow when an application submits many queries against a SQL Server 2005 database that uses simple parameterization
https://support.microsoft.com/?kbid=920206
SQL Server 2005 Mobile Edition
FIX: Error message when you try to insert a row or perform other database operations in a SQL Server 2005 Mobile Edition database: "Wrong page possible database corruption"
https://support.microsoft.com/?kbid=923979
SQL Server 2005 Analysis Services
FIX: Error message when you run a MDX query after you install the cumulative hotfix package for SQL Server 2005 Analysis Services for Itanium-based operating systems (build 9.0.2153): "Internal error: An unexpected exception occured"
https://support.microsoft.com/?kbid=923304
FIX: You receive an access violation error message on a server that is running SQL Server 2005 Analysis Services when you run a MDX query that contains a user-defined function
https://support.microsoft.com/?kbid=918753
FIX: You receive an access violation error message when you try to restore a SQL Server 2005 Analysis Services database
https://support.microsoft.com/?kbid=918747
FIX: A query may return incorrect results when you run the query against a SQL Server 2005 Analysis Services cube
https://support.microsoft.com/?kbid=920340
FIX: You may receive an error message when you try to use the Aggregation Design Wizard to design aggregations in SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=922853
FIX: SQL Server 2005 Analysis Services continually generates minidump files when you try to deploy a new cube
https://support.microsoft.com/?kbid=923301
FIX: The calculated members are not returned in subsequence levels when you run an XML for Analysis (XMLA) script to retrieve child members at a level that is in a hierarchy in SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=923300
FIX: A parent/child dimension contains duplicate calculated members under all the top-level members after you upgrade SQL Server 2000 Analysis Services to SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=911997
FIX: You cannot connect to SQL Server 2000 Analysis Services when you configure the Office Web Components data source connection string to use OLE DB Provider for Analysis Services 9.0 to connect to SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=912631
FIX: SQL Server Analysis Services 2005 system performance may be slow after you use the ADOMD.NET data provider to run an MDX query that returns a large result set from a cube
https://support.microsoft.com/?kbid=919731
SQL Server 2005 Reporting Services
FIX: Error message when you use Report Manager in SQL Server 2005 Reporting Services to view a report: "The request failed with an empty response"