[EN] How to DO IT? My Maintenance SUB-Plans doesn’t work.

Last night I discovered on one of my customers systems, that Maintenance Plan doesn’t work. After few hours I received request form customer with printscreen:

image

Pict. 01 | Error with execution of Maintenance Plans.

When we look into message error we get more details:

image

Pict. 02 | Weekly Batch contains multiple plans…

But what is wrong with that? Customer’s idea was: to executing one batch (in this case weekly) with four subplans such: DBCC CHECKDB, REORGANIZE INDEXES, UPDATE STATISTICS and BACKUP (type FULL) for All Systems Databases. All together looks like this:

Captura_MaintenancePlans2005_08

Pict. 03 | One batch, four subplans and errors

The administrator creates exactly the same weekly batch for Users Databases, but it’s one small and important difference:

Captura_MaintenancePlans2005_09

Pict. 04 | Executing “exactly” the same batch for All User Databases.

 

The difference is very clear: they are four plans in first example and one in second. Let’s comparing differences:

image

Pict. 05 | I’ve got You! Right side: System Databases and Leftt side: User Databases.

As we see our maintenance plans are different, and they cannot work the same. Now we have two options: we can change first batch in SSIS or creat the new one (simple and fast option). But be sure that we will not repeat the design error:

image

Pict. 06 | We must remember about second option: Single schedule for ENTIRE PLAN or no schedule

At the end we have two Maintenance Plans, designed and scheduler very similar (only schedule od execution and types od databases are different):

image

Pict. 07 | Comparing the batches.

Think twice (what you need), design (how it shoud work), think one more (how it looks) time and execute (to check).

[EN] SQL Server 2008 Service Pack 3 Cumulative Update 3 is available

LOGO__SQL_ServerThe second post about “massive update” is for SQL Server 2008 too, but for SP3 this time.

In this Cumulative Update 4 [version build: 10.00.5770.00.] Microsoft resoleved & fixed about fifteen bugs. Below You can find short information about fixed bugs:

VSTS BUG: 834626 | 955850
FIX: Error message when you try to use the binaries from the SQL Server System CLR Types package (SQLSysClrTypes.msi): "Unable to load DLL ‘SqlServerSpatial.dll’: This application has failed to start because the application configuration is incorrect"

VSTS BUG: 834622 | 2531172
FIX: "Unable to obtain the current member" error when you run an MDX query in SQL Server 2008 Analysis Services or in SQL Server 2008 R2 Analysis Services

VSTS BUG: 834616 | 2618680
FIX: "Not registered correctly" error when you use a pull subscription and the Replication Interactive Conflict Resolver

VSTS BUG: 834613 | 2625989
FIX: "Cannot download the information you requested" error in SSRS 2008 when you click a drillthrough report link

VSTS BUG: 834635 | 2628126
FIX: "Fulltext index error during compression or decompression" error when you create a full-text index in SQL Server 2008 or in SQL Server 2008 R2 if the primary key is set to a BIGINT column

VSTS BUG: 834644 | 2635540
FIX: "Incorrect syntax" error message when you use a catalog database whose name contains a special character in SSRS 2008

VSTS BUG: 834647 | 2635827
FIX: Access violation when you run a DBCC CHECKDB command against a database that contains a table that has a spatial index in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 834638 | 2638448
FIX: Access violation when a query is compiled or recompiled in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 834641 | 2638932
FIX: Error when you run the ProcessUpdate command against a cube that has partitions that use aggregation designs in SSAS 2008

VSTS BUG: 834650 | 2640110
FIX: An sp_execute_policy error if both SQL Server 2008 R2 and SQL Server 2008 are installed

VSTS BUG: 856896 | 2653857
FIX: Connection stops responding when you use JDBC Driver in a client application to connect to a SQL Server 2008 database

VSTS BUG: 854951 | 2653893
FIX: It takes a long time to restore a database in SQL Server 2008 R2

VSTS BUG: 834220 | 2660492
FIX: "Internal error" message when you run an MDX query in SQL Server 2008 Analysis Services

VSTS BUG: 855539 | 2660646
FIX: Incorrect result is returned when you use the STBuffer() method on a GEOMETRYCOLLECTION instance that contains two intersecting polygons in SQL Server 2008

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 3

If You want to go directly to download section jump to Request Hotfix Download Site, where You can choose version (for 32-bit, 64-bit, itanium). This release is prepared as multilingual package.

[EN] SQL Server 2008 R2 Service Pack 1 Cumulative Update 4 is available

LOGO__SQLServer2008R2Just few days before last X-Mass Microsoft released cumulative update for SQL Server 2008 R2 SP1. It’a a huge update with fixing a lot of bugs for this SQL Server version.

In this Cumulative Update 4 [version build: 10.50.2796.0] Microsoft resoleved & fixed a lot of bugs for many components of SQL Server.

Below You can find short information about fixed bugs:

VSTS BUG: 834628 | 955850
FIX: Error message when you try to use the binaries from the SQL Server System CLR Types package (SQLSysClrTypes.msi): “Unable to load DLL ‘SqlServerSpatial.dll’: This application has failed to start because the application configuration is incorrect”

VSTS BUG: 765507 | 970198
FIX: You receive an incorrect result when you run a query that uses the row_number function in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 843693 | 2159286
FIX: The Remote Registry service crashes when an application tries to retrieve performance counter data from an instance of SQL Server on another computer

VSTS BUG: 826730 | 2445812
FIX: A column that uses the DATETIME data type does not replicate to an Oracle subscriber by using a transactional replication in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 783498 | 2510788
FIX: Success message is incorrectly logged when a distributed transaction of an SSIS 2005 package, of an SSIS 2008 package or of an SSIS 2008 R2 package is aborted

VSTS BUG: 799308 | 2515286
FIX: “There is no function ‘{urn:schemas-microsoft-com:xml-sql}:variable()” error for an XQuery query that updates the value of an XML column in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 818397 | 2550375
FIX: Deadlock might occur in sys.dm_database_encryption_keys DMV in SQL Server 2008 R2 when you run log shipping from many databases to one secondary server

VSTS BUG: 738050 | 2562753
FIX: Slow performance when an MDX query uses unary operators on parent/child hierarchy members in SSAS 2008 R2 if you define a scope calculation on these members and if the query accesses multiple dates in a time dimension

VSTS BUG: 818842 | 2567366
FIX: Slow performance when you restore a database in SQL Server 2008 R2 if CDC is enabled

VSTS BUG: 818849 | 2580224
FIX: Incorrect results when you commit the Unpivot transformation to a SSIS package in SSIS 2008 or in SSIS 2008 R2

VSTS BUG: 799296 | 2583994
FIX: SSIS Checkpoint restores an incorrect variable value for an Execute SQL Task item of a For Loop Container item in SSIS 2008 or in SSIS 2008 R2 if an SSIS package executes again after it fails or stops

VSTS BUG: 818843 | 2588506
FIX: SQLGetDiagRec function does not return errors in SQL Server 2008 or in SQL Server 2008 R2 if more than 2100 query parameters are sent

VSTS BUG: 799325 | 2588970
FIX: “Server: Msg 7359” error when you run a distributed query in SQL Server 2008 or in SQL Server 2008 R2 if a schema version is updated more than five times

VSTS BUG: 799293 | 2591461
FIX: “Unexpected error from SE OLEDB interface” error when you run a full-text search query in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 818848 | 2597229
FIX: Report Builder 3.0 stops responding if SSRS 2008 R2 uses forms authentication

VSTS BUG: 799305 | 2598903
FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 829282 | 2603910
FIX: Backup fails in SQL Server 2008 or in SQL Server 2008 R2 if you enable change tracking on the database

VSTS BUG: 799312 | 2606301
FIX: High memory usage when you run Replication Snapshot Agent in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 791492 | 2606918
FIX: NULL value in the Retention column in sysmergepublications table and effects on the metadata cleanup process when you set up a merge replication environment in a republishing topology in SQL Server 2008 R2

VSTS BUG: 818853 | 2616117
FIX: Incorrect mail profile is displayed in the Alert System page in SQL Server 2008 R2

VSTS BUG: 798464 | 2616718
FIX: Poor performance when you synchronize the data from a SQL Server 2008 R2 publisher to a SQL Server compact 3.5 subscriber

VSTS BUG: 834621 | 2618676
FIX: Transaction log backup is created even though the full backup is canceled in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 834618 | 2618680
FIX: “Not registered correctly” error when you use a pull subscription and the Replication Interactive Conflict Resolver

VSTS BUG: 805159 | 2620762
FIX: Acknowledgement messages are not sent by a SQL Server 2008 R2 Service Broker target

VSTS BUG: 807413 | 2622668
FIX: Error message when you delete some records of a table at the publisher if the schema name of the table is not [dbo]

VSTS BUG: 818851, 818852 | 2622823
FIX: ghost_record_count values keep increasing in SQL Server 2008 R2

VSTS BUG: 809033 | 2624272
FIX: Error 9013 when you try to start the SQL Server services after you apply SQL Server 2008 R2 SP1 for SQL Server 2008 R2

VSTS BUG: 818844 | 2624527
FIX: Clustered index is not used in the execution plan in SQL Server 2008 R2 if a query uses two or more partitions

VSTS BUG: 812723 | 2626637
FIX: DRILLTHROUGH statement does not work if it is run against some attribute members whose values contain one or more double quotation marks in SSAS 2008 R2

VSTS BUG: 834637 | 2628126
FIX: “Fulltext index error during compression or decompression” error when you create a full-text index in SQL Server 2008 or in SQL Server 2008 R2 if the primary key is set to a BIGINT column

VSTS BUG: 815917 | 2628712
FIX: An infinite loop occurs in a hierarchy that contains a circular relationship in SQL Server 2008 R2

VSTS BUG: 804578 | 2629168
FIX: Internal error when you update a cellset that is returned after you run a query against a perspective in SSAS 2008 R2

VSTS BUG: 817160 | 2629456
FIX: Access violation when you insert a record into a new empty partition in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 816667 | 2632021
FIX: A SSRS 2008 R2 report that has toggle items is not paginated

VSTS BUG: 821110 | 2633271
FIX: SQL Server services cannot be stopped on a computer that has SQL Server 2008 R2 Express Edition installed

VSTS BUG: 822390 | 2634571
FIX: Improvements for the DBCC CHECKDB command may result in faster performance when you use the PHYSICAL_ONLY option

VSTS BUG: 834649 | 2635827
FIX: Access violation when you run a DBCC CHECKDB command against a database that contains a table that has a spatial index in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 827315 | 2638216
FIX: Error message when you run a query that uses an MDX reserved keyword as a parameter name in SSAS 2008 R2

VSTS BUG: 834640 | 2638448
FIX: Access violation when a query is compiled or recompiled in SQL Server 2008 or in SQL Server 2008 R2

VSTS BUG: 828867 | 2639301
FIX: Error message when you review a SSRS 2008 R2 report that has a tablix data region if the region contains some chart or gauge or map items

VSTS BUG: 831931 | 2641923
FIX: Incorrect custom color distribution when you use numeric values for the Start Value and the End Value of custom color distribution buckets in SSRS 2008 R2

VSTS BUG: 832040 | 2641971
FIX: “Error: Data conversion failed” error when you use multiple characters as the column delimiter in Flat File Connection Manager in SSIS 2008 R2

VSTS BUG: 834705 | 2643340
FIX: Action property does not work when you view an SSRS 2008 R2 report in Report Manager

VSTS BUG: 836483 | 2644396
FIX: Merge replication changes are missing on a SQL Server Compact subscriber when they subscribe to a partition in SQL Server 2008 R2

VSTS BUG: 835438 | 2645648
FIX: Export procedure fails when you export a 64-bit SSRS 2008 R2 report that contains multiple levels of document map to the PDF format

VSTS BUG: 822171 | 2646224
FIX: Query plan is displayed as an XML document incorrectly when you set the SHOWPLAN_XML option to ON in SQL Server 2008 R2 SP1

VSTS BUG: 842206 | 2647120
FIX: Incorrect page numbers are displayed when you export a SSRS 2008 R2 report into PDF format

VSTS BUG: 844587 | 2648158
FIX: “The process could not execute” error message when you set a nonzero value in the MaxCmdsInTran parameter of the Log Reader Agent in SQL Server 2008 R2

VSTS BUG: 845530 | 2649359
FIX: An access violation occurs in the “sqlservr!CSbMsgDispatcher::CSbReceivedDialog::AppendMsg” class in SQL Server 2008 R2

VSTS BUG: 836497 | 2651629
FIX: Error message when you use DTA to tune one or more queries against a database that contains many objects in SQL Server 2008 R2

VSTS BUG: 834224 | 2652582
FIX: “Invalid authorization specification” error message when you run the SQL Server 2008 R2 Analysis Services Deployment Wizard by using the SQL Server Authentication mode

VSTS BUG: 837758 | 2653893
FIX: It takes a long time to restore a database in SQL Server 2008 R2

Microsoft has recommended to test all hotfixes before updating in production environment. More information about this release You can find with the article: Cumulative Update 4

If You want to go directly to download section jump to Request Hotfix Download Site, where You can choose version (for 32-bit, 64-bit, itanium). This release is prepared as multilingual package.