SQLServerCentral.com Articles tagged CSV

Excel Function Returns Cell Address

Tue, 04 Jun 2013 06:00:00 UT

This article details an Excel 2010 function to return the cell address of min and max functions.

Tally OH! An Improved SQL 8K “CSV Splitter” Function

Fri, 28 Dec 2012 07:00:00 UT

The Tally Table has proven to be a simple and elegant method for avoiding many varieties of RBAR. Unfortunately, one of its more common uses, that of a CSV splitter, has a well-known and serious performance problem. MVP Jeff Moden shows us what that problem is and how to correct it. (UPDATED with additional info and attachments on 5/12/2011).

The T-SQL of CSV: Comma-Delimited of Errors

Fri, 11 May 2012 06:00:00 UT

Despite the neglect of the basic ODBC drivers over the years, they still afford a neat way of reading from, and writing to, CSV files; and to be able to do so in SQL as if they were tables is somewhat magical. Just to prove it is possible, Phil Factor creates a CSV version of AdventureWorks as a linked server.

Working with Perfmon CSV logs in Powershell

Mon, 05 Mar 2012 07:00:00 UT

When all you have is Powershell and perfmon logs, here's a way you can use them together to perform some analysis.

Tally OH! An Improved SQL 8K “CSV Splitter” Function

Fri, 28 Dec 2012 07:00:00 UT