Browse by Tags

Tagged Content List

Wiki Page: Using Bulk Insert to import inconsistent data format (using pure T-SQL)

pituach

Table of Contents Introduction The problem Our Case Study The solution: STEP 1: Identify the import's file format Finding the problematic columns and the consistent columns format STEP 2: insert the data into temporary table Step 3: parsing the data into the final table Summary Comments Resources...

on15 Sep 2013
Wiki Page: Generate XML - Column Names with their Values as text() Enclosed within their Column Name Tag

Naomi N

The most commonly used XML format is the following: (column names with their values as text() enclosed within their column name tag) Lets find out how to generate the following XML for table provided below: < Employees > < field Name = "ID" >1</ field >...

on8 Sep 2013
Wiki Page: Avoid T (space) while generating XML using FOR XML clause

SathyanarrayananS

The following code shows an example on how to avoid T (space) while generating XML using FOR XML clause Sample Data: DECLARE @Employee TABLE (ID INT , Name VARCHAR (100), DOJ DATETIME) INSERT @Employee SELECT 1, 'Sathya' , '2013-06-08 08:50...

on8 Sep 2013
Wiki Page: BizTalk Server 2010: Database BizTalkDTADb

Maheshkumar S Tiwari

Table of Contents Tables Tables to be aware of SQL Queries Find Orphaned messages in the tracking database Query Transactions Query Instances Query transaction by host name Get message count for all applications from In Out Events References See Also This article will contain information about the...

on23 Aug 2013
Wiki Page: Change Data Capture Known has CDC

Manjunath C Bhat

Change Data Capture popularly known as CDC is a new feature in SQL Server 2008 that records insert, update and delete activity in SQL Server tables. A good example of how this feature can be used is in performing periodic updates to a data warehouse. CDC records (or captures) DML activity on designated...

on21 Aug 2013
Wiki Page: BizTalk Server 2010: Backup Compression

Steef-Jan Wiggers

Table of Contents Introduction Compression feature See Also Introduction One of the new features of BizTalk Server 2010 is backup compression of BizTalk database. This feature has some advantages like: Less disk space is required for data files, Less I/O operations, A faster backup and restore...

on15 Aug 2013
Wiki Page: Query Taking non-Consistent Time to Execute

Ed Price - MSFT

There might be following reasons for different timings: 1. Different hardware configurations CPU, RAM, etc. on different servers Note: If we're running the same query on different servers, we can not expect the same time, but we may expect similar times, so the huge difference is a case...

on4 Aug 2013
Wiki Page: Useful TSQL Scripts for your DBA Toolbox

dplotnikov - mvp

The following set of useful TSQL scripts are the result of great discussions on the MSDN forums. The initial set of scripts were supplied by Harry SQL DBA with additional scripts resulting from other forum discussions. The intent of using the wiki for this content is to allow all users to add new scripts...

on26 Aug 2012