Browse by Tags

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

    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...
  • Wiki Page: Generate XML - Column Names with their Values as text() Enclosed within their Column Name Tag

    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 >...
  • Wiki Page: Avoid T (space) while generating XML using FOR XML clause

    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...
  • Wiki Page: BizTalk Server 2010: Database BizTalkDTADb

    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...
  • Wiki Page: Change Data Capture Known has CDC

    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...
  • Wiki Page: BizTalk Server 2010: Backup Compression

    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...
  • Wiki Page: Query Taking non-Consistent Time to Execute

    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...
  • Wiki Page: Useful TSQL Scripts for your DBA Toolbox

    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...
Page 1 of 1 (8 items)
Can't find it? Write it!