MSMVPS.COM

The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.

October 2007 - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Blogs

SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Syndication

News

Blog Archive List

Sort by: Most Recent | Most Viewed | Most Commented

FIX: Error messages when you run a SQL Server 2005 Integration Services package after you install Cumulative Update 2 for SQL Server 2005 Service Pack 2: "Data conversion failed" and "SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR&

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition,SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX...

Published Wed, Oct 31 2007 21:07 by SSQA.net

Filed under: sql server, ssis, error, kba, integration services, SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR
FIX: SQL Server 2005 may send error information for the same problem many times when a fatal error occurs

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications FIX: SQL Server 2005 may send error information for the same problem many times...

Published Wed, Oct 31 2007 14:11 by SSQA.net

Filed under: sql server, error, kba, processor, information, fatal error
You receive an error message when you try to uninstall the second named instance of SQL Server 2005

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications You receive an error message when you try to uninstall the second named instance of...

Published Wed, Oct 31 2007 9:04 by SSQA.net

Filed under: sql server, error, kba, installation, uninstall, named instance
SQL Server 2005 standard query tuning options - plan guide for performance testing how to?

You may be aware that plan guides will help the optimizer to perform better and a general recommendation is to use the relevant USE PLAN query hint when the other standard query tuning options are failed. It is also necessary to test through the results...

Published Tue, Oct 30 2007 22:41 by SSQA.net

Filed under: sql server, performance, indexes, services, hotfix, planning, service pack, best practice, testing, plan guide
Write Function in SQL Server 2005

One of the functions available in SQL Server 2005 that allows you to update a character column of size max is WRITE Function. In fact we can consider this as alternate to STUFF function which wont work for columns with Max length declare @t table(v nvarchar...

Published Tue, Oct 30 2007 7:05 by SSQA.net

Filed under: sql server, Stuff, Write
FIX: You cannot run some SQL Server 2005 Integration Services packages in Business Intelligence Development Studio if you also run the same packages by using the Dtexec.exe utility

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: You cannot run some SQL Server 2005...

Published Mon, Oct 29 2007 1:22 by SSQA.net

Filed under: sql server, package, ssis, kba, dts, bids, integration services, dtexec
How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Reporting Services Notification Contents: New and Major Modifications How...

Published Sun, Oct 28 2007 23:56 by SSQA.net

Filed under: sql server, kba, service pack2, xp, configuration
Error message in the SQL Server Errorlog file after you upgrade SQL Server 2000 to SQL Server 2005 on a server that is running Windows Server 2003: "Unable to update password policy"

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications Error message in the SQL Server Errorlog file...

Published Sun, Oct 28 2007 9:53 by SSQA.net

Filed under: sql server, security, kba, password, servers, windows 2003, policy
FIX: Error message when you use the "bcp_sendrow" function in a SQL Server 2005-based application that uses a SQL Native Client provider: "For BCP, all variable-length data must have either a length-prefix or a terminator specified"

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Published Sat, Oct 27 2007 9:45 by SSQA.net

Filed under: sql server, error, kba, function, bcp, native client, length-prefix, terminator
How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server code name "Longhorn"

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete How to install and how to configure SQL Server 2005 Reporting Services on...

Published Sat, Oct 27 2007 5:50 by SSQA.net

Filed under: sql server, kba, reporting services, configuration, servers, windows 2008
Best practices for Data Importing using SQL Server native methods

Ever wondered SQL Server Data Importing Do's and Don'ts, with a set of best practices. Import of data is a common task in any database platform and when it becomes regular you have to take care lot of incompatibilities. In particular SQL Server...

Published Fri, Oct 26 2007 18:08 by SSQA.net

Filed under: sql server, data, best practices, import, testing, source, export, live data
FIX: Error message when you run the DBCC CHECKTABLE statement or the DBCC CHECKDB statement in Microsoft SQL Server 2005: "Column '<ColumnName>' value is out of range for data type 'float'"

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQLL Server 2005 Enterpris X64 Edition Notification Contents: New and Major Modifications...

Published Fri, Oct 26 2007 14:40 by SSQA.net

Filed under: sql server, database, kba, datatype, column, dbcc checktable, float, dbcc checkdb
FIX: A query that involves an outer join operation runs very slowly in Microsoft SQL Server 2005

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Published Fri, Oct 26 2007 9:38 by SSQA.net

Filed under: sql server, performance, kba, joins, slow, outer join
Listen to MVPs and Industry experts - podcast taken in SQLBITS Conferences on Oct 06th 2007

Quickly you can listen to the MVPs and Industry Experts that were caught as Podcast by Dave M from NextGen. This was taken during SQLBits conference that was held in Microsoft HQ campus in Reading, UK on October 06th 2007. View Video Format: mp3 Duration...

Published Thu, Oct 25 2007 18:04 by SSQA.net

Filed under: sql server, microsoft, mvp, podcast, experts, listen
Developer Developer Developer event 24th November 2007 - in Microsoft HQ campus Reading - UK

You can now register for DDD6 on Saturday 24th November 2007: http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032357828&Culture=en-GB . The agenda will be posted on the DDD6 site shortly. Don't miss it. It gets booked up REAL quick...

Published Thu, Oct 25 2007 18:00 by SSQA.net

Filed under: sql server, microsoft, developer, community, events, conference
Stored Procedures caught me with too many recomplies - way out to avoid it

A common scenario in SQL Server environment that often application users complained about slow performance and same time you observe high CPU usage/spikes on the SQL Server instance, so better to follow the methods from HighCPU-whyitis blog and still...

Published Thu, Oct 25 2007 3:35 by SSQA.net

Filed under: sql server, performance, indexes, blogs, kba, stored procedure, high cpu, recompile, too many
Performance is slow when you run a query in SQL Server 2005 that updates a table on a linked server and then joins the table to a table on the local server

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Performance is slow when you run a query...

Published Wed, Oct 24 2007 23:14 by SSQA.net

Filed under: sql server, performance, kba, joins, slow, linked server
FIX: Dates in the Datetimepicker control appear in the incorrect format when you view a report of SQL Server 2005 Reporting Services with SP2 on a server that is set to a German locale

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: Dates in the Datetimepicker control appear in the incorrect format when...

Published Wed, Oct 24 2007 3:38 by SSQA.net

Filed under: datetime, sql server, kba, service pack2, reporting services, language, report viewer, format, locale, german
FIX: Error message when you synchronize a merge replication in a replication topology that contains two or more re-publishers in SQL Server 2005: "21997 Failed to allocate new identity range"

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: Error message when you synchronize...

Published Tue, Oct 23 2007 20:16 by SSQA.net

Filed under: sql server, replication, kba, publisher, message, identity key, topology, errorr 21997
FIX: Error message when you run a DML statement against a table in a SQL Server 2005 Integration Services package: "Msg 6549, Level 16, State 1, Procedure sp_FuzzyLookupTableMaintenanceInvoke, Line 0"

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: Error message when you run a DML statement...

Published Tue, Oct 23 2007 18:17 by SSQA.net

Filed under: sql server, ssis, error, kba, fuzzy, lookup, reporting services, sp_FuzzyLookupTableMaintenanceInvoke, error 6549

1 2 3 4 5 Next >

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

zines:andrewbelon.com

October 2007 - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Blogs

Syndication

Recent Posts

Tags

News

Archives

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

Blog Archive List

FIX: Error messages when you run a SQL Server 2005 Integration Services package after you install Cumulative Update 2 for SQL Server 2005 Service Pack 2: "Data conversion failed" and "SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR&

FIX: SQL Server 2005 may send error information for the same problem many times when a fatal error occurs

You receive an error message when you try to uninstall the second named instance of SQL Server 2005

SQL Server 2005 standard query tuning options - plan guide for performance testing how to?

Write Function in SQL Server 2005

FIX: You cannot run some SQL Server 2005 Integration Services packages in Business Intelligence Development Studio if you also run the same packages by using the Dtexec.exe utility

How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server

Error message in the SQL Server Errorlog file after you upgrade SQL Server 2000 to SQL Server 2005 on a server that is running Windows Server 2003: "Unable to update password policy"

FIX: Error message when you use the "bcp_sendrow" function in a SQL Server 2005-based application that uses a SQL Native Client provider: "For BCP, all variable-length data must have either a length-prefix or a terminator specified"

How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server code name "Longhorn"

Best practices for Data Importing using SQL Server native methods

FIX: Error message when you run the DBCC CHECKTABLE statement or the DBCC CHECKDB statement in Microsoft SQL Server 2005: "Column '<ColumnName>' value is out of range for data type 'float'"

FIX: A query that involves an outer join operation runs very slowly in Microsoft SQL Server 2005

Listen to MVPs and Industry experts - podcast taken in SQLBITS Conferences on Oct 06th 2007

Developer Developer Developer event 24th November 2007 - in Microsoft HQ campus Reading - UK

Stored Procedures caught me with too many recomplies - way out to avoid it

Performance is slow when you run a query in SQL Server 2005 that updates a table on a linked server and then joins the table to a table on the local server

FIX: Dates in the Datetimepicker control appear in the incorrect format when you view a report of SQL Server 2005 Reporting Services with SP2 on a server that is set to a German locale

FIX: Error message when you synchronize a merge replication in a replication topology that contains two or more re-publishers in SQL Server 2005: "21997 Failed to allocate new identity range"

FIX: Error message when you run a DML statement against a table in a SQL Server 2005 Integration Services package: "Msg 6549, Level 16, State 1, Procedure sp_FuzzyLookupTableMaintenanceInvoke, Line 0"