May 2007 - Technical Rollup Mail - SQL
News
New Virtualisation Rights Available for SQL Server 2005 Enterprise Edition
Virtualization can reduce costs and increase performance and now it’s available at no extra cost for SQL Server Enterprise Edition customers. Understand what virtualization can do for your business and review the white paper on how to use SQL Server in a virtual environment.
https://www.microsoft.com/sql/howtobuy/virtualization.mspx
SQL Server 2005 Books Online Scoped Search
See this new link from the SQL Server Books Online team. It allows you a "Windows Live" search format providing a more precise and targeted search format for accessing the most up-to-date content in the SQL Server books online.
https://search.live.com/macros/sql_server_user_education/booksonline
Getting Optimal Performance with Integration Services Lookups – SQL Server Performance Team Blog
Most users see good performance from SSIS packages using out-of-the-box configurations and with little tuning. Sometimes, though, it is necessary to do tuning to get optimal performance. One of the most commonly used transformations is the Lookup transformation. There are several techniques for getting optimal performance from a Lookup transform in SSIS. A few of these are surprising the first time you see them. This article discusses some tuning techniques that we have found can be important in different situations.
Documents
Comparing Enterprise Development Productivity: SQL Server 2005 versus Oracle Database 10g
This independent productivity study, prepared by 3 Leaf, compares two developers working independently to provide the same added features and functionality to a baseline application. One developer worked with SQL Server 2005, and the other used Oracle Database 10g. By comparing the time required by each developer to perform equivalent development tasks, this study quantifies one instance of improved development efficiency in SQL Server 2005, relative to Oracle Database 10g.
https://www.microsoft.com/sql/prodinfo/compare/oracle/devprodoracle.mspx
SQL Server 2005 Row Versioning-Based Transaction Isolation
Microsoft SQL Server 2005 provides nonlocking, nonblocking read consistency to your users through snapshot isolation and read committed isolation using row versioning. Find out when you can use these features to improve performance and reduce latency in your applications.
https://msdn2.microsoft.com/en-us/library/ms345124.aspx
Downloads
Example corrupt SQL 2005 database to play with and some backup/restore things to try – from the SQL Server Storage Engine Team
The WinZip file in the link below contains a backup of a simple 2005 database called 'broken'. It has a simple table called 'brokentable' (c1 int, c2 varchar(7000)) with one row in it. The table has a single data page with page ID (1:143) that I've corrupted so the page checksum is corrupt. You can try all sorts of things with this – there are many examples in the linked web page.
Example corrupt SQL 2000 database to play with and some backup/restore things to try – from the SQL Server Storage Engine Team
The WinZip file in the link below contains a backup of a simple 2000 database called 'broken' . It has a simple table called 'brokentable' (c1 int, c2 varchar(7000)) with one row in it. The table has a single data page with page ID (1:75) that I've corrupted so the page header is corrupt. When you try selecting from the table, you should get a 605 error that kills the connection. See the previous post for instructions on restoring it etc.
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
Microsoft Business Intelligence Conference – May 9th to 11th, Seattle WA.
Join us for the first-ever Worldwide Microsoft Business Intelligence Conference
This exciting and informative conference for customers and partners will showcase Microsoft’s market-leading BI products, solution expertise and customer successes. The event will feature keynote addresses by Steve Ballmer, CEO of Microsoft, and Jeff Raikes, President, Microsoft Business Division, and is designed to educate customers and partners on every aspect of Microsoft’s BI offering. You can also expect educational tracks, customer best practices sessions, the first-ever Microsoft BI Awards presentation, hands-on labs, and much more! The Conference will be held at the Washington State Convention & Trade Center in the heart of downtown Seattle, Washington.
https://www.microsoftbiconference.com/
MSDN Webcast: Introducing LINQ to DataSet (Level 200) - Wednesday, May 2, 2007. 10:00 A.M.–11:00 A.M. Pacific Time
Join this session as we explore how new technologies within Microsoft Visual Studio code name "Orcas" make working with data a better experience. One such technology is Microsoft .NET Language Integrated Query (LINQ), code name for a set of extensions to the Microsoft .NET Framework that encompass language-integrated data query, set, and transform operations. We explore how LINQ to DataSet enables you to take advantage of the power of LINQ in your DataSet-based applications. We also demonstrate how using LINQ to DataSet can help you improve the performance and reliability of your existing code and use this exciting new functionality.
MSDN Webcast: Introducing LINQ to DataSet (Level 200)
MSDN Webcast: ADO.NET Step by Step (Part 1 of 4): Getting Started (Level 200) - Wednesday, May 9, 2007. 9:00 A.M.–10:00 A.M. Pacific Time
This webcast series is based on Microsoft ADO.NET Step by Step, by Rebecca M. Riordan (Microsoft Press, 2002). In this first session, we provide an overview of ADO.NET, the data-access component of the Microsoft .NET Framework. We explain how ADO.NET works with almost any component on nearly every platform that understands XML. We also discuss the database functionality of Microsoft Visual Basic .NET and Microsoft Visual C# .NET. Attend this session to start working with ADO.NET right away with easy-to-grasp examples drawn from the real-world challenges developers face every day. Learn how you can take advantage of the ADO.NET object model to develop data-bound Windows Forms and Web Forms, and see an example of binding data to a simple Windows Form. We explore how ADO.NET interacts with XML and describe how to access older versions of ActiveX Data Objects (ADO) from the .NET Framework environment. Join us for insightful tips and expert explanations of how ADO.NET can help you accelerate development productivity, build faster applications, and deliver more powerful results.
MSDN Webcast: ADO.NET Step by Step (Part 1 of 4): Getting Started (Level 200)
MSDN Webcast: Building a Simple Recommendation Engine with SQL Server 2005 Data Mining (Level 200) - Tuesday, May 15, 2007. 10:00 A.M.–11:00 A.M. Pacific Time
The powerful recommendation engines that major e-commerce sites use to tempt customers into new and additional sales are one of the most visible uses of data mining. This technology often seems unobtainable for smaller businesses and their developers; however, in this webcast, we discuss how Microsoft SQL Server 2005 Analysis Services offers powerful, predictive analysis with a comprehensive range of simple data mining technologies. Join us to learn how you can take advantage of this technology and build a recommendation engine that meets the needs of your organization.
MSDN Webcast: Building a Simple Recommendation Engine with SQL Server 2005 Data Mining (Level 200)
MSDN Webcast: ADO.NET Step by Step (Part 2 of 4): Creating Connections (Level 200) - Wednesday, May 16, 2007. 10:00 A.M.–11:00 A.M. Pacific Time
This webcast series is based on Microsoft ADO.NET Step by Step, by Rebecca M. Riordan (Microsoft Press, 2002). In this second session, we further explore ADO.NET, the data-access component of the Microsoft .NET Framework, by examining connections to data:
· How they are made.
· Connection properties.
· Methods for manipulating connections.
· Handling events raised by connections.
We also discuss the database functionality of Microsoft Visual Basic .NET and Microsoft Visual C# .NET. Attend this session to start working with ADO.NET right away with easy-to-grasp examples drawn from the real-world challenges developers face every day. Learn how you can use the ADO.NET object model to develop data-bound Windows Forms and Web Forms, and see an example of binding data to a simple Windows Form. We explain how ADO.NET interacts with XML and how to access older versions of ActiveX Data Objects (ADO) from the .NET Framework. Join us for insightful tips and expert explanations of how ADO.NET can help you accelerate development productivity, build faster applications, and deliver more powerful results.
MSDN Webcast: ADO.NET Step by Step (Part 2 of 4): Creating Connections (Level 200)
MSDN Webcast: ADO.NET Step by Step (Part 3 of 4): Data Commands and the DataReader (Level 200) - Wednesday, May 23, 2007. 9:00 A.M.–10:00 A.M. Pacific Time
This webcast series is based on Microsoft ADO.NET Step by Step, by Rebecca M. Riordan (Microsoft Press, 2002). In this third session, we further explore ADO.NET, the data-access component of the Microsoft .NET Framework, by examining a basic foundational element in ADO.NET: the DataReader. Learn how to retrieve recordsets from databases using the ADO.NET DataReader and how to manipulate the data with commands. We discuss the database functionality of Microsoft Visual Basic .NET and Microsoft Visual C# .NET. Attend this session to start working with ADO.NET right away with easy-to-grasp examples drawn from the real-world challenges developers face every day. Find out how you can use the ADO.NET object model to develop data-bound Windows Forms and Web Forms. We explain how ADO.NET interacts with XML and describe how to access older versions of ActiveX Data Objects (ADO) from the .NET Framework environment. Join us for insightful tips and expert explanations of how ADO.NET can help you accelerate development productivity, build faster applications, and deliver more powerful results.
MSDN Webcast: ADO.NET Step by Step (Part 3 of 4): Data Commands and the DataReader (Level 200)
MSDN Webcast: ADO.NET Step by Step (Part 4 of 4): The DataAdapter (Level 200) - Wednesday, May 30, 2007. 9:00 A.M.–10:00 A.M. Pacific Time
This webcast series is based on Microsoft ADO.NET Step by Step, by Rebecca M. Riordan (Microsoft Press, 2002). In this fourth session, we further explore ADO.NET, the data-access component of the Microsoft .NET Framework, by examining how the DataAdapter facilitates the communication between the DataSet and the database. Learn how the DataSet provides methods to select, insert, update, and delete data that has been changed or added to the database. We also discuss the database functionality of Microsoft Visual Basic .NET and Microsoft Visual C# .NET. Attend this session to start working with ADO.NET right away with easy-to-grasp examples drawn from the real-world challenges developers face every day. Learn how you can use the ADO.NET object model to develop data-bound Windows Forms and Web Forms. We explain how ADO.NET interacts with XML and how to access older versions of ActiveX Data Objects (ADO) from the .NET Framework environment. Join us for insightful tips and expert explanations of how ADO.NET can help you accelerate development productivity, build faster applications, and deliver more powerful results.
MSDN Webcast: ADO.NET Step by Step (Part 4 of 4): The DataAdapter (Level 200)
Further on-demand webcasts are available here: https://www.microsoft.com/events/series/technetsqlserver2005.mspx
New KB’s
SQL Server 2000 Standard Edition
Space is not released after you delete some rows from a table in SQL Server 2000
https://support.microsoft.com/?kbid=934378
Database corruption occurs after you run the "alter table" Transact-SQL command to change a column from not null to null in Microsoft SQL Server 2000
https://support.microsoft.com/?kbid=928810
SQL Server 2005 Service Pack 2
You cannot install SQL Server 2005 Service Pack 2 on a computer that is running SQL Server 2005 Reporting Services after you install the .NET Framework 2.0
https://support.microsoft.com/?kbid=934652
Error message when you install SQL Server 2005 SP2, SQL Server Express SP2, or SQL Server Express with Advanced Services SP2: "SQL Server Setup failed to execute a command for server configuration. CREATE DATABASE failed"
https://support.microsoft.com/?kbid=935371
Cumulative update package (build 3161) for SQL Server 2005 Service Pack 2 is available
https://support.microsoft.com/?kbid=935356
SQL Server 2005 Standard Edition
FIX: Error message when you run a query in Microsoft SQL Server 2005: "Msg 8624, Level 16, State 116 Internal Query Processor Error: The query processor could not produce a query plan"
https://support.microsoft.com/?kbid=931329
FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2047
https://support.microsoft.com/?kbid=932555
FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2153 and later builds
https://support.microsoft.com/?kbid=931593
FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1399
https://support.microsoft.com/?kbid=932557
FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1500 and later builds
https://support.microsoft.com/?kbid=932556
FIX: You may receive an access violation when you perform a bulk copy operation in SQL Server 2005
https://support.microsoft.com/?kbid=933549
FIX: You receive a Visual Studio Just-In-Time Debugger error message when you debug or run a SQL Server 2005 Integration Services package in SQL Server Business Intelligence Development
https://support.microsoft.com/?kbid=922436
FIX: Error message when you try to use Database Mail to send an e-mail message in SQL Server 2005: "profile name is not valid (Microsoft SQL Server, Error 14607)"
https://support.microsoft.com/?kbid=934226
FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3042 through 3053
https://support.microsoft.com/?kbid=934458
FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3150 through 3158
https://support.microsoft.com/?kbid=934459
FIX: The Distribution Agent does not deliver commands to the Subscriber even if the Distribution Agent is running in SQL Server 2005
https://support.microsoft.com/?kbid=934188
SQL Server Setup fails unexpectedly when you try to install SQL Server 2005 Service Pack 2
https://support.microsoft.com/?kbid=935297
Error message when you log on to an instance of Microsoft SQL Server 2005 from SQL Server Management Studio: "Timeout expired. This timeout period elapsed prior to completion of the operation or the server is not responding"
https://support.microsoft.com/?kbid=934751
FIX: The Distribution Agent generates an access violation when you configure a transaction publication to run an additional script after the snapshot is applied at the subscriber in SQL Server 2005
https://support.microsoft.com/?kbid=934109
FIX: SQL Server 2005 database engine generates failed assertion errors when you use the Replication Monitor to monitor the distribution database
https://support.microsoft.com/?kbid=934106
BUG: The Installation Progress dialog box displays a status of Failure for the Database Services component when you install SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2 on an instance of SQL Server 2005
https://support.microsoft.com/?kbid=932011
An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
https://support.microsoft.com/?kbid=935897
BUG: Error message when you try to install SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2 from the existing active node: "The product instance <InstanceName> been patched with more recent updates"
https://support.microsoft.com/?kbid=934749
How to use the 64-bit SQL Server Agent to schedule a SQL Server 2005 Integration Services package
https://support.microsoft.com/?kbid=934653
FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005
https://support.microsoft.com/?kbid=933564
Error message when you try to install SQL Server 2005 on a volume mount point: "There is not enough space on the destination disk for the current SQL Server installation"
https://support.microsoft.com/?kbid=934012
How to run a SQL Server 2005 Integration Services package as a SQL Server Agent job step
https://support.microsoft.com/?kbid=912911
Issues that you may encounter when you install a named instance of one or more SQL Server 2005 components and specify different installation locations for one or more of the components
https://support.microsoft.com/?kbid=933945
Error message when you use a number that is more than 28 in the common language runtime for SQL Server 2005: "System.OverflowException: Conversion overflows"
https://support.microsoft.com/?kbid=932288
You receive syntax error messages when you use transactional replication in SQL Server 2005
https://support.microsoft.com/?kbid=935563
SQL Server 2005 Enterprise Edition
FIX: Error message when you try to retrieve rows from a cursor that uses the OPTION (RECOMPILE) query hint in SQL Server 2005: "Could not complete cursor operation because the table schema changed after the cursor was declared"
https://support.microsoft.com/?kbid=930775
SQL Server 2005 Express Edition
Some shared components are not installed in the correct folder when you install SQL Server 2005 Express Edition on a computer that is running a 64-bit version of Windows Vista
https://support.microsoft.com/?kbid=934750
SQL Server 2005 Mobile Edition
FIX: You do not receive an error message when an error occurs while you use the dialog boxes of SQL Server 2005 Compact Edition
https://support.microsoft.com/?kbid=934434
FIX: You cannot use SQL Server 2005 Compact Edition on an ARMV4i-based device that is running Windows CE .NET 4.2
https://support.microsoft.com/?kbid=934386
SQL Server 2005 Analysis Services
FIX: Error message when you use the Association Rules algorithm to process a data mining model in SQL Server 2005 Analysis Services: "This number of attributes exceeds the attribute limit of 5000 allowed by the current version of the algorithm"
https://support.microsoft.com/?kbid=932609
When you run an MDX query in SQL Server 2005 Analysis Services, the query takes longer to run than expected
https://support.microsoft.com/?kbid=935995
An MDX query takes longer than you expect to finish in SQL Server 2005 Analysis Services