[SQL Server Data Warehousing]Data replicated from a Table to a Table across database

Hi,

We have two database, From First database we have to copy the table values and insert into table which is in Second database. Since there is no way(like modified date etc) in the table we can't find which record is added/modified/removed from the first table.

Presently we have a batch job to truncate all the records in the second table and insert all the records from the First table. I am not convinced with this way because this is a huge table and frequently we end up deleting the records and inserting and we make the sql server busy. Instead i need better way to handle this scenario. Do we have any other better way to handle this.

Thanks in advance.

---

badri prasad, Software Engineer

.

social.technet.microsoft.com/Forums

[SQL Server]Advanced SQL Server 2008 Extended Events with Examples

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

.

sqlteam.com

[SQL Server]Testing with Profiler Custom Events and Database Snapshots

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

.

sqlteam.com

[SQL Server]Efficiently Reuse Gaps in an Identity Column

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

.

sqlteam.com

Pricing of PDW Appliance

Hi All:

I have been searching hard for the pricing & details of SQL SERVER 2012 PDW Appliance (both Dell and HP) but got nothing. Can anyone show me where i can find some relevant info?

Cheers

.

social.technet.microsoft.com/Forums

[SQL Server]Using REPLACE in an UPDATE statement

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

.

sqlteam.com

Replace function ineffective with the string more than 90 chars

Hi,

I am working on T-SQL stored procedure. In my code i use REPLACE function. It works fine until i pass the string of length more than 90 characters.

where geography in (''' + REPLACE(@Geography,',',''',''') + '''' + ')'

The geography value is passed from SSRS report, where i send the parameter with the JOIN function using comma seperator. In this stored procedure i frame the multivalued parameter using the replace function. I have tried changing the parameter resolution to nvarchar(500) no changes notified

The problem is that it is working ABSOLUTELY fine until i pass  @Geography with more than 90 characters.

---

Bunch of thanks ~ Deva ~ 

.

social.technet.microsoft.com/Forums