SSIS has a problem with stored procedures that use temporary tables to generate output. This article describes a useful technique for working around this problem.

Finding a better candidate for your clustered indexes

by Additional Articles

MSSQLTips.com

Indexing

When creating tables it is difficult to determine exactly how the data will be accessed. Therefore when clustered indexes are chosen they are often just the ID column that makes the row unique. This may be a good choice, but once the application has been used and data access statistics are available you may need to go back and make some adjustments to your tables to ensure your clustered indexes are providing a benefit and not a drain on your applications.

How Would You Rate This? - Database Weekly (Dec 29, 2008)

by Steve Jones

SQLServerCentral.com

Editorial - MP3

Steve Jones wonders if Microsoft is doing a good job with their efforts to patch SQL Server security issues?

Peer-to-Peer Replication in SQL Server 2008

by Additional Articles

SQLServerCentral

This article describes the new Peer-to-Peer replication features in SQL Server 2008

Merry Christmas 2008

by Steve Jones

SQLServerCentral.com

Steve Jones wishes the SQLServerCentral community a Merry Christmas and Happy Holiday!

SQL Queries Are Coming To Town

by Steve Jones

SQLServerCentral.com

humor

The holiday classic updated for SQLServerCentral.

Enjoy Christmas Eve

by Steve Jones

SQLServerCentral.com

Editorial

The day before Christmas and Steve Jones shares some holiday thoughts.

How To Get the List of Files from an FTP Server in SQL Server Integration Services (SSIS) 2005

by Additional Articles

MSSQLTips.com

Integration Services (SSIS)

We use the FTP task in SSIS to process a number of files from an FTP server. We would like to implement a step in our SSIS packages that would retrieve the list of files that are available on the FTP server before we try to process them.