Here's an example of what Grant is telling you to do, replace your function and query with this:

SELECT e.ID, e.Name, n.JobDescription, n.Hours
  FROM EcentricTestTable ett
 ...

Who will be using the linked servers?  If it is a session such as a SQL Agent job which is local to the server, then it should work.  For the...

Also it should be noted that trying to optimize a query by rearranging the join order in the vast majority of cases will not help.  SQL Server's optimizer will try...

This is in one database and when run manually the stored procedure works correctly and populates three fields in the merge statement. When you run it through the job...

To answer your first question, in the article you linked it says:

"Blocked process threshold uses the deadlock monitor background thread to walk through the list of tasks waiting for a...

If you don't know where to begin, may I suggest starting with Wait Statistics to figure out what types of bottlenecks your system has:

https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

Now looking at those numbers only...

How often will this view be queried?  Having queries frequently go across a linked server is a notorious way to kill performance.  Does the consumer of this query need real...

I've found that Azure Data Studio is only useful if you want to run the query from a Linux workstation instead of Windows, or if you need to query against...

Just a warning with using the Database Diagramming feature of Management Studio, if...

if you have a backup file and you are not sure what it is from or when it was taken, you can use the RESTORE HEADERONLY command to examine it:

Looking at your pesession file, I see the first query is doing an index scan on Object12 and Object13, then hash matching them together.  The reads of Object12 seem to...

Offhand it's difficult to tell if separating out 1 to 1 related columns would have any benefit.  It would probably depend on how often those columns are populated, how often...

this looks like the execution plan for creating a bunch of stored procedures, not the execution of a stored procedure.  Did you run the estimated plan against the stored procedure...

If you want a set of data to be processed by a stored procedure, could you simply load it into a staging table, then run the stored procedure to process...

...The Applicant Data has two sets of addresses and two sets of contact info as each applicant could have two of each.  It also includes numerous boolean fields related...