SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Invisible community contributions, Visible success to users
October 2007 - Posts
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&
Published 31 October 7 9:7 PM |
SSQA.net
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...
FIX: SQL Server 2005 may send error information for the same problem many times when a fatal error occurs
Published 31 October 7 2:11 PM |
SSQA.net
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...
You receive an error message when you try to uninstall the second named instance of SQL Server 2005
Published 31 October 7 9:4 AM |
SSQA.net
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...
SQL Server 2005 standard query tuning options - plan guide for performance testing how to?
Published 30 October 7 10:41 PM |
SSQA.net
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...
Write Function in SQL Server 2005
Published 30 October 7 7:5 AM |
SSQA.net
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...
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
Published 29 October 7 1:22 AM |
SSQA.net
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...
How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
Published 28 October 7 11:56 PM |
SSQA.net
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...
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"
Published 28 October 7 9:53 AM |
SSQA.net
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...
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"
Published 27 October 7 9:45 AM |
SSQA.net
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...
How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server code name "Longhorn"
Published 27 October 7 5:50 AM |
SSQA.net
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...
Best practices for Data Importing using SQL Server native methods
Published 26 October 7 6:8 PM |
SSQA.net
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...
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'"
Published 26 October 7 2:40 PM |
SSQA.net
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...
FIX: A query that involves an outer join operation runs very slowly in Microsoft SQL Server 2005
Published 26 October 7 9:38 AM |
SSQA.net
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...
Listen to MVPs and Industry experts - podcast taken in SQLBITS Conferences on Oct 06th 2007
Published 25 October 7 6:4 PM |
SSQA.net
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...
Developer Developer Developer event 24th November 2007 - in Microsoft HQ campus Reading - UK
Published 25 October 7 6:0 PM |
SSQA.net
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...
Stored Procedures caught me with too many recomplies - way out to avoid it
Published 25 October 7 3:35 AM |
SSQA.net
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...
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
Published 24 October 7 11:14 PM |
SSQA.net
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...
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
Published 24 October 7 3:38 AM |
SSQA.net
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...
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"
Published 23 October 7 8:16 PM |
SSQA.net
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...
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"
Published 23 October 7 6:17 PM |
SSQA.net
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...
More Posts
Next page »
Search
Go
This Blog
Home
Contact
About
Tags
2005
2008
best practice
best practices
blogs
conference
database
databases
dmv
download
error
indexes
kba
microsoft
performance
query
replication
reporting services
security
server
sql server
ssis
ssms
tsql
webcast
Community
Home
Blogs
Media
Groups
Archives
September 2008 (8)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
News
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go