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

37,344 reads

Blogs

Would You Pass the SQL Server Certifications Please? What Do You Mean We're Out?

By

I have held various certifications through my DBA career, from CompTIA A+ certification back...

PASS Summit 2020 Mental Health Presentation Eval Comments

By

I first starting presenting on mental health last December in Charlotte, NC on mental...

PASS Summit 2020 Mental Health Presentation Eval Comments

By

I first starting presenting on mental health last December in Charlotte, NC on mental...

Read the latest Blogs

Forums

Interpreting Index Usage Stats on an Availability Group

By data.jedi.ken

I've been querying sys.dm_db_index_usage_stats on the nodes of an availability group, and I've noticed...

SQL Server Performance Counters

By alex.sqldba

Here's a question that feels like I'm asking if a tree falls in the...

Ideas for Auditing

By Tava

I'm currently looking to design some auditing on my SQL application and am wondering...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

WHILE in R

See possible answers