Browse by Tags

What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?

Published 26 March 8 3:1 AM | SSQA.net

Fragmentation is dearest friend of database when you need to deal with Performance, so by using the DBCC statements and other methods here you can deal the database level fragmentation, what about the physical level fragmentation? So what is the best...

Filed under: sql server, performance, blogs, dbcc, disk space, object, file, best practice, monitoring, showcontig, defrag, diskkeeper

How to enable the SQL Server 2005 Integration Services process to generate a dump file when the process experiences exceptions

Published 30 August 7 2: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 Notification Contents: New and Major Modifications How to enable the SQL Server 2005 Integration...

Filed under: sql server, integration, ssis, services, kba, process, file, dump, exception

SSIS Error: Text was truncated or one or more characters had no match in the target code page

Published 29 August 7 2:54 AM | SSQA.net

This error started generating since last 2 days on a scheduled job that uses SSIS to import content from a flat file. Eventually we found that a derived column within the table and the flat file flow where dates in YYYYMMDD are changed to MM/DD/YYYY format...

Filed under: sql server, ssis, error, jobs, scheduled, error log, file, truncated, destination, source

Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in BCP data-file

Published 28 August 7 10:10 AM | SSQA.net

When you use BCP then you would definelty get to see this error "Unexpected EOF encountered in BCP data-file". Not only that I have seen this as one of the frequently asked questions (FAQs) and for a moment you might be thinking why there is...

Filed under: sql server, i/o, import, file, bulk-logged, destination, bulk insert, source, bcp

FIX: Error message when you import data from a flat file in a SQL Server 2005 Integration Services (SSIS) package: "There is a partial row at the end of the file"

Published 5 July 7 9:6 AM | SSQA.net

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 FIX: Error message when you import data from...

Filed under: ssis, kba, file