Nice Question

I am using 'Pragmatic Task factory' tasks/adapters to Synchronize the Salesforce data with SQL Server data. It is very cool.

@hugo - Good analysis. I like detailed explanation. Thanks for sharing

Nice one, thanks for sharing.

stephen.long.1 (9/3/2014)

SQLRNNR (9/3/2014)

Raghavendra Mudugal (9/3/2014)

Seriously, I am one step away from swatting my laptop screen, every time I see your avatar automatically my hand raises from...

+1

Learned new syntax

Adding new table doesn't require downtime at all.

If your queries are not using SELECT * then you are ok to add new column (as it will not affect your application...

+1 😛

Recursive trigger is...

+1

The idea of the query is not bad (though a bit repetitive). But the execution is rather poor. Too bad.

Thanks for the question

Same here - Nice question

where you want to manipulate the value? During INSERT operation?

Or you are trying to build SQL Query to retrieve the data as per your need?

As you mentioned dirty read is ok then use

SELECT <<column names>> FROM table1 WITH (NOLOCK)

Also, nolock hint should not be used with DELETE & UPDATE statements. This is in deprecated...

Luis Cazares (8/25/2014)

jshahan (8/25/2014)

I like PIVOT because...