SSIS and Stored procedures using temp tables
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.
2008-12-26
27,635 reads
Articles
Finding a better candidate for your clustered indexes
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.
2008-12-26
3,880 reads
How Would You Rate This? - Database Weekly (Dec 29, 2008)
Steve Jones wonders if Microsoft is doing a good job with their efforts to patch SQL Server security issues?
2008-12-26
720 reads
Peer-to-Peer Replication in SQL Server 2008
This article describes the new Peer-to-Peer replication features in SQL Server 2008
2008-12-26
2,534 reads
Merry Christmas 2008
Steve Jones wishes the SQLServerCentral community a Merry Christmas and Happy Holiday!
2008-12-25
19 reads
2008-12-25
3,349 reads
How To Get the List of Files from an FTP Server in SQL Server Integration Services (SSIS) 2005
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.
2008-12-24
4,073 reads
2008-12-24
144 reads
2008-12-24
133 reads
2008-12-24
119 reads
Blogs
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers