Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag CSV Rss

Search for any content tagged csv

   Items 1 to 5 of 5   
 

Excel Function Returns Cell Address

This article details an Excel 2010 function to return the cell address of min and max functions.  Read more...
By Russ Mulkey 2013/06/04 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 5,734 reads

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

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).  Read more...
By Jeff Moden 2012/12/28 (first published: 2011/05/02) | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 43,106 reads

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

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.  Read more...
By Additional Articles 2012/05/11 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 4,760 reads

Working with Perfmon CSV logs in Powershell

When all you have is Powershell and perfmon logs, here's a way you can use them together to perform some analysis.  Read more...
By Hemanth Damecharla 2012/03/05 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,924 reads

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

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).  Read more...
By Jeff Moden 2012/12/28 (first published: 2011/05/02) | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 43,106 reads
   Items 1 to 5 of 5