Zach Nichter

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: )

35,456 reads

Blogs

SSAS Tabular – Process Add memory consumption

By

For me it’s a bit surprising how little information can be found regarding the...

Our SQL Server 2019 Administration Inside Out Fun Author Survey

By

SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...

What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup

By

Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...

Read the latest Blogs

Forums

How to populate Temp table from Stored Procedure

By rkordonsky 63916

I am trying to put the result of Stored Procedure execution into Temp Table:...

Web page listing SQL code

By EamonSQL

Hi, I'm building a web page for my users that will list example SQL...

Going from Failover Cluster Instance to Availability Group with Azure Replica

By jcourtjrSQL

So if we have a FCI on premises, and want to add Availability Group...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers