Duluth, GA
+ 678-753-4494
contact@datahills.us

Sql Server : Convert VARBINARY column data into raw file

  • Posted by Sqltimes
  • On May 30, 2015
  • 0 Comments
Quick one today: Recently, there was an interesting request. We have an application that stores shopping receipts in database table in binary format. To run some ELT processes on the content, we needed gather all the receipts; To be transferred ETL team. Seems like a simple task, but there was no ready template to generate […]
Read More
 

Sql Server : Export VARBINARY column data into raw file on disk using SSIS

  • Posted by Sqltimes
  • On May 23, 2015
  • 0 Comments
Quick one today: Recently, we were tasked with an interesting task. One of our applications stores digital shopping receipts in a database table in binary format. A different team wanted an export of all the millions of such digital receipts in separate files for their ETL engine. Initially, T-SQL was used to export all the […]
Read More
 

Sql Server: Convert VARBINARY column data to raw files using T-SQL

  • Posted by Sqltimes
  • On May 16, 2015
  • 0 Comments
Quick one today: A few months ago, there was a new requirement to export millions of records in a table column to raw files on a disk. This column contains millions of shopping receipts stored in binary format in database tables. Early on, I stumbled up on a tip that gave me a good idea […]
Read More
 

Sql Server : How to TRUNCATE table variable

  • Posted by Sqltimes
  • On May 2, 2015
  • 0 Comments
Quick one today: Table variables are ubiquitous. There are several benefits to using them in your T-SQL code. There are some nuances between table variable and temporary table that we discussed previously; Today, we’ll look at dropping table variable. How do we DROP a table variable? A table variable is not fully a table, so […]
Read More