We have a datacentre in London with many users in Glasgow. The Glasgow users frequently experience dire application performance while London users of the same applications have no problems....

When I eagerly walked into my current role nearly 2 years ago, I was staggered by the number of linked servers (often 5 or 6 instances of 3 different linked...

no need to enable change tracking - think of it more like...

you're still executing the function once per row

you should persist the data

ALTER TABLE dbo.ctest

ADD MLT AS dbo.sludf_AnswerTableValue(CasMachineID, CasID, '000-002', 'Code') PERSISTED

this means it is stored and not recalculated on each...

just google it, you'll find dozens of articles

extended events sql save to table

that's what I searched for

other way round... almost looks like someone forgot to commit the transaction - and with those lock hints....ouch

i' advise scripting up your logins and users then drop them all.

create your logins first and then your users within the database.

failing that it's sp_changuserslogin.

my bad... it's only when you create the publication and go to choose the distributor that it checks - but would advise (if possible) to go as high as you...

yes, but your distributor always has to be the highest sql version compared to publisher and subscriber

it wasn't too clear from your description what you wanted

if you want to update each row based on it's own values then

update driver set rateid= case when rateid=40 then 0...

select y.id,y.name1,x.address1,y.newaddressflag,y.current address from ##temp y inner join (select distinct id,address1 from #temp where newaddressflag='Y') x on x.id=y.id

right click on the server and use activity monitor - order it by the head blocker column - you should be able to see a better picture of what is...

something like

select y.id,y.name1,x.address1,x.newaddressflag,y.currentaddress from ##temp y inner join (select distinct id,address1 from ##temp where newadressflag='y') as x  on y.id=x.id

first of all, are these functions deterministic? how many times do you use the view ? do you reference any of these functions in the where clause?

personally i've used persisted...

are you running sql server express? in older versions it would throttle your speed down if you had more than 5 connections open - every extra connection halved its speed...