Using OPENROWSET to read large files into SQL Server
OPENROWSET is a T-SQL function that allows for reading data from many sources including using the SQL Server’s BULK import capability.
2008-12-29
6,687 reads
Additional 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
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
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
Web Mining: Creating, Enhancing, Mining and Acting on Web Data
Customer interactions reveal important trends and patterns that can help a company design a website that effectively communicates and markets its products and services.
2008-12-24
1,509 reads
How do I run code automatically when SQL Server starts?
The need to run a stored procedure or SQL Agent Job when SQL Server or SQL Agent starts is a common requirement in the world of SQL Server administration. This article gives an overview of the ways to execute SQL stored procedures or SQL Agent jobs on startup.
2008-12-23
2,546 reads
Powerful Geographical Visualisations made easy with SQL 2008 Spatial (Part 2)
This is the final article in a series on how to perform data visualisation with SQL Server 2008
2008-12-23
2,302 reads
Powerful Geographical Visualisations made easy with SQL 2008 Spatial (Part 1)
This article is part one of a two part series on how to perform data visualisation with SQL Server 2008
2008-12-22
3,010 reads
SQL inner and outer joins: Basics for getting started
Learn the basics to create a SQL inner join and SQL outer join. Get examples on how to use them for a customized result set querying more than one table.
2008-12-22
5,822 reads
Simple Column Chart for Analysis Services Data
This article focuses upon Column charts, and extends the examination of Reporting Services charts for Analysis Services data sources that we began in Introducing Reporting Services Charts for Analysis Services.
2008-12-19
2,293 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
The Large Encoded Value
Comments posted to this topic are about the item The Large Encoded Value
The Side Job
Comments posted to this topic are about the item The Side Job
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers