Zach Nichter


SQLServerCentral Article

Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The

SQL Server has extensions to allow one to call COM based objects from within the server using T-SQL. While this is an interesting feature, it's may not be the best way to structure your applications due to performance reasons. New author Zach Nichter of ScalabilityExperts.com brings us an analysis of different ways of writing out to a file from within SQL Server. Read on to see the most efficient method of generating files on your server.

5 (2)

2006-11-10 (first published: )

39,369 reads

Blogs

Copying large files from SharePoint Online

By

I recently worked on a project where we needed to copy some large files...

How Long has Your SQL Server Been Online

By

This week’s blog post will help you check your SQL Servers up-time. There are...

The less you hear from or about the DBAs the better they are doing their job.

By

Something I’ve been thinking about recently is that DBAs are best when they are...

Read the latest Blogs

Forums

Ordering String_Split()

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Ordering String_Split()

Worse Before Better

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Worse Before Better

Azure SQL Managed Backup for on-prem databases

By database diva

I have a SQL 2017 on-prem database server that the client wants to back...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers