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

Content with tag MERGE Rss

   Items 1 to 20 of 35    Older >>
 

Template - Type 6 SCD Stored Procedure

Template to create a Type 6 slowly changing dimension stored procedure  Read more...
By Marie Bayer 2015/02/17 | Source: SQLServerCentral.com | Category: template
Rating: |  Discuss |   Briefcase | 2,088 reads

Performance of the SQL MERGE vs. INSERT/UPDATE

The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?  Read more...
By Dwain Camps 2015/02/06 (first published: 2013/10/28) | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 30,675 reads

Using the MERGE Statement to Perform an UPSERT

The term UPSERT has been coined to refer to an operation that inserts rows into a table if they don’t exist, otherwise they are updated. To perform the UPSERT operation Microsoft introduced the MERGE statement. Not only does the MERGE statement support the UPSERT concept, but it also supports deleting records. Greg Larsen discusses how to use the MERGE statement to UPDATE, INSERT and DELETE records from a target table.   Read more...
By Additional Articles 2014/12/22 | Source: Database Journal | Category: merge
Rating:  Rate this |   Briefcase | 11,855 reads

Merge Targets

By Steve Jones 2014/09/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,007 reads

Stairway to T-SQL DML Level 12: Using the MERGE Statement

The final level of this stairway looks at the MERGE statement in detail, focusing on how to perform insert, update and delete logic using the MERGE statement.  Read more...
By Gregory Larsen 2014/08/20 (first published: 2013/01/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 17,696 reads

Create MERGE statements with data!

A script to create MERGE statements with data for specific tables.  Read more...
By Jason Selburg 2014/07/16 | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 3,542 reads

Cursor-Killing: Retrieving Recently Modified Data

Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? In the next part of an ongoing series, we look at ways to efficiently retrieve recently modified data.  Read more...
By Edward Pollack 2014/06/02 | Source: SQLServerCentral.com | Category: cursor
Rating: |  Discuss |   Briefcase | 6,319 reads

Duplicate Detection and Management

Inevitably, every DBA is eventually asked to delete, merge, or otherwise report on duplicate data. There are many tools at our disposal to make this task both simple and efficient to complete. Read on for simple steps and examples to effectively deal with duplicate data.  Read more...
By Edward Pollack 2014/04/29 | Source: SQLServerCentral.com | Category: duplicate
Rating: |  Discuss |   Briefcase | 6,375 reads

Template - Type 6 SCD Stored Procedure

Template to create a Type 6 slowly changing dimension stored procedure  Read more...
By Marie Bayer 2015/02/17 | Source: SQLServerCentral.com | Category: template
Rating: |  Discuss |   Briefcase | 2,088 reads

Generate MERGE statements with Table data

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...
By Daniel Nolan 2014/01/07 | Source: SQLServerCentral.com | Category: generate
Rating: |  Discuss |   Briefcase | 4,772 reads

Performance of the SQL MERGE vs. INSERT/UPDATE

The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?  Read more...
By Dwain Camps 2015/02/06 (first published: 2013/10/28) | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 30,675 reads

Implementing, loading and optimizing a Type 2 Slowly Changing Fact Table

This article shows how to implement a Slowly Changing Facts Table, how to overcome the problems encountered when using the MERGE statement to process the data and suggest a minimal set of indexes to aid data loading and quering.   Read more...
Rating: |  Discuss |   Briefcase | 5,542 reads

Managing Slowly Changing Dimension with MERGE Statement in SQL Server

Slowly Changing Dimension (SCD) Transformation is a quick and easy way to manage smaller slowly changing dimensions but it has several limitations and does not perform well when the number of rows or columns gets larger. Arshad Ali explores some of the alternatives you can use for managing larger slowly changing dimensions.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,308 reads

A Hazard of Using the SQL Merge Statement

The SQL MERGE statement can make your DML querying more efficient but you need to take care or you may get burned  Read more...
By Dwain Camps 2013/04/03 | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 15,267 reads

Using the SQL Server MERGE Statement to Process Type 2 Slowly Changing Dimensions

The MERGE statement is powerful and multifunctional, yet it can be hard to master. SOmetimes the MERGE statement that just doesn't do what it's needed to do, like process a Type 2 slowly-changing dimension. Check out this tip to learn more.  Read more...
By Additional Articles 2013/03/08 | Source: MSSQLTips.com | Category: merge
Rating:  Rate this |   Briefcase | 3,214 reads

Merge

By Ole Kristian Velstadbråten Bangås 2013/02/14 | Category: merge
Rating: (not yet rated) |  Discuss |   Briefcase | 2,037 reads

If you are using indexed views and MERGE, please read this!

Here is some information about an important MERGE “wrong results” bug, involving indexed views, that could be affecting the accuracy of your queries right now, and what options you have for working around the problem.  Read more...
By Aaron Bertrand 2013/02/14 | Source: SQLPerformance.com | Category: indexed views
Rating:  Rate this |   Briefcase | 4,119 reads

Stairway to T-SQL DML Level 12: Using the MERGE Statement

The final level of this stairway looks at the MERGE statement in detail, focusing on how to perform insert, update and delete logic using the MERGE statement.  Read more...
By Gregory Larsen 2014/08/20 (first published: 2013/01/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 17,696 reads

Merge, Metadata and the Data Mart ETL

Here's a great method for managing ETL for data marts and small data warehouses with just T-SQL.  Read more...
By Christopher Ross 2012/12/27 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 4,526 reads

Generate MERGE statements with Table data

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...
By Daniel Nolan 2014/01/07 | Source: SQLServerCentral.com | Category: generate
Rating: |  Discuss |   Briefcase | 4,772 reads
   Items 1 to 20 of 35    Older >>
 
Tags
t-sql (14)    
sql server 2008 (5)    
data warehousing (2)    
indexed views (2)    
indexing (2)    
performance (2)    
slowly changing dimensions (2)    
auto create sql (1)    
automation (1)    
blogs (1)    
business intelligence (1)    
common table expressions (cte) (1)    
cte (1)    
cursor (1)    
data (1)    
data mart (1)    
data synchronization (1)    
data warehouse (1)    
delete (1)    
deleted (1)    
domain (1)    
duplicate (1)    
edw (1)    
etl (1)    
generate (1)    
generator (1)    
identity property (1)    
insert (1)    
inserted (1)    
integration services (ssis) (1)    
lookup (1)    
metadata (1)    
migration (1)    
multithreaded partition access (1)    
output clause (1)    
partition (1)    
partition aligned index view (1)    
partition elimination (1)    
partitioning (1)    
partitioning and compression (1)    
partitioning and parallel execution (1)    
post-deploy (1)    
recursion (1)    
reference (1)    
scope_identity (1)    
sliding windows (1)    
slowly changing dimension (1)    
slowly changing facts (1)    
split (1)    
sqlcmd mode (1)    
ssdt (1)    
stairway series (1)    
static (1)    
stored procedure (1)    
switch (1)    
template (1)    
update (1)