Monthly Archives: May 2014

Converting from Teradata Timestamp to SQL Server Datetime ‏

Teradata has a timestamp data type that appears to be equivalent to a SQL Server datetime.  It is not. Attempting to use the SSIS Data Conversion task will likely fail with a truncation error.  While the solution below is extremely … Continue reading

Posted in SQL Server Integration Services, Teradata | Tagged , , , , | Leave a comment

Index Maintenance and msdb database

I recently analyzed index fragmentation and found that msdb had some severely fragmented indexes. This was definitely the case on older instances where backup history had been deleted over time. The tables with fragmented indexes were: backupset backupfile backupmediaset Lesson … Continue reading

Posted in Database Administration | Tagged , | Leave a comment