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

40,898 reads

Blogs

Tell My Story of Public Speaking

By

This month the fine folks behind New Stars of Data and the DataGrillen Newcomer...

The Last Trip of 2022

By

It’s the last trip for me today. I head to the UK for a...

How to cluster SAP ASCS/SCS with SIOS DataKeeper on VMware ESXi Servers

By

This article describes the steps you take to prepare the VMware infrastructure for installing...

Read the latest Blogs

Forums

Mass update on Clustered Columnstore indexes

By SqlRon

Hi, we have a FACT table with 35 billion rows, partitioned on daily level....

should atemp table be used from looping even when single table is used in a loop

By rajemessage 14195

hi, We have a master table, single table which I loop thought, to do...

Exporting from SQL to XML issue

By Jobs90312

Hi everyone, So I have a table which consists of different IDs of a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers