Viewing 15 posts - 151 through 165 (of 286 total)
Hi,Am not able to co-relate with the data between the two. Could you please explain little bit.
June 6, 2011 at 10:37 pm
Leaned a bit internal today.
Yes me too. Thanks Gail!!!
June 6, 2011 at 12:03 pm
Here you may *also* need to have a left join (Temp table and Destination)while inserting where keys are equal and destination table has null values for mismatch records.
June 6, 2011 at 5:45 am
probably he would have meant checkpoint has nothing to do with this scenario. Once the dll run, it started working on...:-)
June 6, 2011 at 2:54 am
Hi Muthu,Can you provide us a link please?
June 6, 2011 at 2:45 am
muthukkumaran Kaliyamoorthy (6/6/2011)
GilaMonster (6/6/2011)
An in-place update.@sqlzealot-81,
What gail told is
An inplace update only change the byte.But an exception update trigger and replication.This as you told delete followed by an insert.
How...
June 6, 2011 at 2:34 am
GilaMonster (6/6/2011)
Jason L (6/6/2011)
rebuilding the a clustered index will also rebuild any non-clustered indexes on that table.
It does not.
Rebuilding the clustered index rebuilds just the clustered index. To rebuild all...
June 6, 2011 at 2:07 am
Any specific reason, you need to keep the file in DB?
However, Filestream is an option.
June 6, 2011 at 2:04 am
GilaMonster (6/6/2011)
muthukkumaran Kaliyamoorthy (6/6/2011)
sqlzealot-81 (6/6/2011)
Hi, Thought of going back to basics, Whats an update. Is it an operation of delete and insert?
Yep, True the update will delete the value first...
June 6, 2011 at 2:02 am
I tested sometimes back where I found update deletes and then inserts.
However, when I think about the replication, say, I am having a transactional replication, If I update some...
June 6, 2011 at 2:01 am
Actually we faced the same issue for one of my collegue. The dll just gave the error, however it started working on it from next server start. So thought of...
June 5, 2011 at 11:00 pm
As pietlindan said, you need to revisit your design.
However, check the following would work or not....Again, it would better if you could revisit the design .
Select substring(WkstationID,0,4),COUNT(1) From Workstation
Group by...
June 5, 2011 at 10:34 pm
Wow!! thats really interesting....Can you provide us the link?
I am not able to relate the same with it...
June 3, 2011 at 10:54 am
Viewing 15 posts - 151 through 165 (of 286 total)