Skip to content

Jim Salasek's SQL Server Blog

Sharing what I learn about Sql Server

  • Home
  • About
  • Contact

Recent Posts

  • Modify SSRS Subscription Retries April 7, 2021
  • Unable to enlist in the transaction using a Linked Server. Msg 7391, Level 16, State 2 March 2, 2021
  • Msg 4701, Level 16 trying to truncate table through Linked Server February 2, 2021
  • Msg 7399, Level 16, State 1 Linked Server. Access Denied January 5, 2021
  • Another feature I wish SQL Server had. December 3, 2020
January 2017
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
    Feb »

Day: January 31, 2017

Deleting Duplicate Data

Duplicate data in your database?  I will show you two ways on how to delete duplicate data in your Sql Server database.  How does it get there?  The ways are limitless, but you more than likely do not have an adequate unique index or unique constraint setup for your table.

Continue reading Deleting Duplicate Data

Posted on January 31, 2017January 15, 2017Categories UncategorizedLeave a comment on Deleting Duplicate Data
Create a website or blog at WordPress.com