Tags » SQL Server 2008 R2

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

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. 245 more words

DBA

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

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. 364 more words

DBA

Change Data Capture (CDC) in SQL Server

When you apply Change Data Capture features on a database table, a mirror of the tracked table is created with the same column structure of the original table, but with additional columns that include the metadata used to summarize the nature of the change in the database table row.   2,929 more words

Database

Sql Server : How to TRUNCATE table variable

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… 151 more words

DBA

T-SQL Metadata Queries

Stumbled upon this great post by Marco Schreuder about how to collect source system metadata with T-SQL queries:
The blog post is a few years old, but still the queries might come in handy. 32 more words

SQL Server 2012

Sql Server Error : The IDENTITY function can only be used when the SELECT statement has an INTO clause.

Quick one today:

Recently, ran into an interesting error message that looks very complicated, but is fairly straight one.

Msg 177, Level 15, State 1, Line 1
The IDENTITY function can only be used when the SELECT statement has an INTO clause. 84 more words
DBA

Sql Server : Keyboard shortcut to change to UPPER CASE in Sql Server Management Studio (SSMS)

Quick one today:

As alwways, there is value in formatting SQL code in a proper way. There are several ‘proper’ ways to format code; And all are great. 114 more words

DBA