An UPDATE statement will only ever change existing rows, not add them. If you want to both update and insert rows, you need to use MERGE.

Select
 id,
 sum(time)
From #Temp
group by id

August 19, 2018 at 1:58 pm

#2002421

You may want to test the performance of doing so, I'd be surprised if storing transaction logs on an encrypted volume didn't impact performance considerably more than just doing in-database...

What has almost certainly happened is that your account was a member of the Local Administrators group in Windows and that group was previously a member of the sysadmin role...

I think it depends on how you're likely to query it. One option is certainly to have an "owner" id as part of each node, another to have a separate...

+1 to Jeff's comments. The only time I'd use Simple recovery mode is if the database is entirely disposable (if f.e. it's just used for post-processing data collected elsewhere in...

A better question might be what you are trying to accomplish by doing this? I mean you could just add columns to the temp table with the SPID and current...

You can't pass parameters to a view. So you can either convert it into an Inline Table-Valued Function (which is effectively a parameterised view) or leave off the WHERE clause...

If any kind of group membership was changed for the service account, the running process will not have the relevant security tokens (because these are assigned when a service first...

For what it's worth, the "right to forget" in the GDPR does not apply if there are other legal requirements to retain the data - Article 17, paragraph 3 (b).