As RVSC48 says, use Add/Remove Programs.  You can choose which components and/or...

Sam

You hint at the answer in the title of your thread.  Since you're inserting a column of values in one go, those values all have to have the...

I'm not saying that they necessarily looked at the execution plans at all - just that that may be a reason why they insisted on access to the server.

It depends.  I suppose they may have looked at tempdb or at the execution plans.  However, they ought to specify why they need access to the whole server.

John

Nader

Difficult when I can't see what's in your database.  But try changing referencing_id to referenced_id in the join predicate of the anchor part.  I recommend that you arrange...

Nader

Yes, that's right.  The view sys.sql_expression_dependencies contains one row for each column dependency, so if, for example, ViewA explicitly selects three columns from TableA, there'll be three rows. ...

Nader

The reason you aren't getting any results from the recursive section of your CTE is the AND referencing_id IS NULL clause.  referencing_id is not a nullable...

You've still used name in the second part of the CTE, which is where I said you need to change it.

John

Here's a quick and dirty method.  Provided you know in advance the names of the servers and logins and the new passwords, you could use Excel to generate a script...

You'll probably want to run a trace or Extended Events session to see who or what is connecting as this user.  There may be several reports set up to use...

So you want people to be able to query your database, but you don't want there to be any performance penalty?  I'm afraid there's no such thing as a free...

You didn't specify any expected results based on the sample data you provided, so I'm just guessing here, but what happens if you change the outer join to an inner...