SqlServerKudos

kba

1
kudos

Kudos

List of KBA links updated specific to SQL Server 2008

published 4 hours, 35 minutes ago posted by

sa 9 days, 2 hours, 56 minutes ago

List of KBA links updated specific to SQL Server 2008

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications Error message when you try to install a SQL Server 2008 cumulative update or service pack: "The patch installer has failed to update the shared features" http://support.microsoft.com/kb/2216468/en-US New 7/8/2010 8:33:00 AM GMT Error message when you try to open a project in SQL Server 2008: "The located assembly's manifest definition...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: configuration, cumulative update, fulltext, kba, service broker, SQL Server

1
kudos

Kudos

SQL Server 2005 Standard Edition, Enterprise Edition & X64 based Knowledge Base Article changes

published 98 days, 11 hours, 53 minutes ago posted by

sa 102 days, 14 hours, 4 minutes ago

SQL Server 2005 Standard Edition, Enterprise Edition & X64 based Knowledge Base Article changes

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New FIX: You receive a "Provider Load Failure" error message or the WMIPRVSE.EXE process stops responding when you use a SQL Server 2005 WMI provider to obtain information about SQL Server 2005 services http://support.microsoft.com/kb/980142/en-US FIX: Proactive caching starts unexpectedly when you insert data in SQL Server 2005 http://support.microsoft.com/kb/98... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: best practice, database mail, dbcc checkdb, enterprise edition, kba, Performance, SQL Server, SSAS, ssiss, SSRS, standard edition, x64

1
kudos

Kudos

Troubleshoot error messages :: List of modified Knowledge Base (KBA) articles

published 110 days, 12 hours, 47 minutes ago posted by

sa 119 days, 14 hours, 18 minutes ago

Troubleshoot error messages :: List of modified Knowledge Base (KBA) articles

Here are the important KBAs that are helpful to troubleshoot the error/warning messages that you get within SQL Server arena. The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications How to troubleshoot Msg 7105 in SQL Server http://support.microsoft.com/kb/2015760/en-US New 4/1/2010 6:20:00 PM GMT How to troubleshoot Msg 5180 in SQL Server http://support.microsoft.com/kb/2015747/en-US New 4/1/2010.... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: enterprise edition, error, kba, memory leak, message, SQL Server

1
kudos

Kudos

Improve Performance on query execution - control Parameter Sniffing

published 121 days, 13 hours, 34 minutes ago posted by

sa 130 days, 15 hours, 13 minutes ago

Improve Performance on query execution - control Parameter Sniffing

Going back to basics 'parameter sniffing' is a process where SQL Optimizer helps (sniffs) the execution process any current parameter values during compilation or reccompilation process. It will attain a pass-along values to the query optimizer so that the values can be used to generate a potential faster query execution plan/policy. That helps in some cases but at not all of the execution fashion, such as huge volume of rows are returned. It is nothing but SQL optimizer replaces the constants 'literal'.... (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: kba, Maintenance, monitor, parallel execution, Performance, profiler, Query, SQL Server

1
kudos

Kudos

SQL Server Failover Cluster and Filestream feature enabled, issues surronding the failover and failback.

published 126 days, 13 hours, 58 minutes ago posted by

sa 135 days, 14 hours, 34 minutes ago

SQL Server Failover Cluster and Filestream feature enabled, issues surronding the failover and failback.

At the first instance the error is clear that some problem with SQL resource that was allocated to the Cluster resource. Just a background on SQL Server Failover Clustering, that the server cluster consists of a failover cluster instance that runs under Cluster Services (MSCS). The instance of SQL Server might be hosted by Microsoft MSCS-based nodes that provide the Microsoft Server Cluster, say if problems exist on the nodes that host the server cluster, those problems may manifest themselves as...(read... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Cluster, failover, filestream, kba, SQL Server, SQL Server 2008

1
kudos

Kudos

Cumulative Update Package 10 for SQL Server 2008 - have a look at list of bug fixes

published 126 days, 13 hours, 58 minutes ago posted by

sa 135 days, 15 hours, 34 minutes ago

Cumulative Update Package 10 for SQL Server 2008 - have a look at list of bug fixes

In the recent times Microsoft Release Services adopted the 935897 Incremental Servicing Model (ISM) for SQL Server team to deliver hotfixes for reported problems, also the new 822499 naming schema for Microsoft SQL Server software update packages. In this regard here is the 10th instalment of Cumulative Update package for SQL Server 2008, so when you apply the fixes the build of the cumulative update package is also known as build 10.00.1835.00. A note of caution on backout plan if there is any problem..... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: best practice, build, cumulative update, database mirroring, kba, package, service pack, SQL Server

1
kudos

Kudos

A Java application crashes when it connects to SQL Server 2008 by using Java Database Connectivity Driver 2.0

published 176 days, 19 hours, 43 minutes ago posted by

sa 186 days, 3 hours, 28 minutes ago

A Java application crashes when it connects to SQL Server 2008 by using Java Database Connectivity Driver 2.0

Product: Microsoft SQL Server 2008 Standard & Microsoft SQL Server 2008 Enterprise Editions Notification Contents: New and Major Modifications A Java application crashes when it connects to SQL Server 2008 by using Java Database Connectivity Driver 2.0 http://support.microsoft.com/kb/977305/en-US...(read more) (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: Connections, crash, drivers, Java, kba, SQL Server

1
kudos

Kudos

List of SQL Server 2008 Enterprise Edition Knowledge Base Notification update

published 183 days, 20 hours, 14 minutes ago posted by

sa 193 days, 4 hours, 7 minutes ago

List of SQL Server 2008 Enterprise Edition Knowledge Base Notification update

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications FIX: The LogReader agent unexpectedly consumes all CPU resources when the agent handles a failed connection in a SQL Server 2008 transactional replication http://support.microsoft.com/kb/976991/en-US FIX: Only the first 2000 characters are returned by the fn_get_audit_file() function when you use it to obtain the information of an audit...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: cdc, change data capture, cpu, data files, enterprise edition, kba, SQL Server, SSIS

1
kudos

Kudos

List of SQL Server 2008 Standard Edition Knowledge Base Notification updates

published 183 days, 20 hours, 14 minutes ago posted by

sa 193 days, 8 hours, 12 minutes ago

List of SQL Server 2008 Standard Edition Knowledge Base Notification updates

Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications FIX: Connector 1.0 for SAP BI throws an exception when data is being loaded in parallel in a SSIS 2008 package http://support.microsoft.com/kb/975058/en-US FIX: The check phase of the WMI service fails when you set up a SQL Server 2008 cluster http://support.microsoft.com/kb/975374/en-US FIX: You receive error message 8672 when you run a MERGE statement in SQL Server 2008 http://support.m... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: BI, business intelligence, data files, Extended Events, kba, message, processor, sap, SQL Server, SSIS, standard edition

1
kudos

Kudos

FIX: Error message when you try to rebuild one partition of an index on an indexed view in SQL Server 2005: "A system assertion check has failed. Check the SQL Server error log for details."

published 305 days, 5 hours, 56 minutes ago posted by

sa 308 days, 13 hours, 36 minutes ago

FIX: Error message when you try to rebuild one partition of an index on an indexed view in SQL Server 2005: "A system assertion check has failed. Check the SQL Server error log for details."

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New FIX: Error message when you try to rebuild one partition of an index on an indexed view in SQL Server 2005: "A system assertion check has failed. Check the SQL Server error log for details." http://support.microsoft.com/kb/970726/en-US...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: assertion, error, error log, index, kba, parallel queries, SQL Server

1
kudos

Kudos

FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008

published 306 days, 6 hours, 1 minute ago posted by

sa 309 days, 14 hours, 7 minutes ago

FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008 http://support.microsoft.com/kb/972498/en-US...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: agent, data flow, error, fix, kba, low memory, package, SQL Server, SSIS

1
kudos

Kudos

FIX: Error message when you run the Distribution Agent to synchronize the subscribers with the publisher in Microsoft SQL Server 2005:" The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect"

published 307 days, 6 hours, 6 minutes ago posted by

sa 309 days, 22 hours, 22 minutes ago

FIX: Error message when you run the Distribution Agent to synchronize the subscribers with the publisher in Microsoft SQL Server 2005:" The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect"

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New FIX: Error message when you run the Distribution Agent to synchronize the subscribers with the publisher in Microsoft SQL Server 2005:" The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect" http://support.microsoft.com/kb/973103/en-US...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: distribution agent, kba, publication, replication, rpc, SQL Server, stream, synchronization, tds

Welcome!

kba

List of KBA links updated specific to SQL Server 2008

SQL Server 2005 Standard Edition, Enterprise Edition & X64 based Knowledge Base Article changes

Troubleshoot error messages :: List of modified Knowledge Base (KBA) articles

Improve Performance on query execution - control Parameter Sniffing

SQL Server Failover Cluster and Filestream feature enabled, issues surronding the failover and failback.

Cumulative Update Package 10 for SQL Server 2008 - have a look at list of bug fixes

A Java application crashes when it connects to SQL Server 2008 by using Java Database Connectivity Driver 2.0

List of SQL Server 2008 Enterprise Edition Knowledge Base Notification update

List of SQL Server 2008 Standard Edition Knowledge Base Notification updates

Recently updated Microsoft SQL Server 2008 Standard Knowledge Base Articles

FIX: Error message when you try to rebuild one partition of an index on an indexed view in SQL Server 2005: "A system assertion check has failed. Check the SQL Server error log for details."

FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008

FIX: Error message when you run the Distribution Agent to synchronize the subscribers with the publisher in Microsoft SQL Server 2005:" The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect"

Open ID Login

Standard Login

Forgot Password?

Sign up