Yep. Timeout is strictly a client connection setting. You can control the remote query timeout setting, but it's still very much a client-side problem. Otherwise, this sure sounds like...

The execution plan doesn't have runtime metrics (what's called an "Actual Plan" in SSMS), so it's a little hard to know precisely what's happening. You say it's returning two rows....

As @ratbak says, a SELECT won't affect data in tables. Any given SELECT operation can cause blocking as it uses resources, which can slow down things. However, that's extremely common...

Here's the Microsoft documentation

Read uncommitted simply doesn't take out some locks, allowing for reads as data gets changed. This can result in incorrect data, missing or duplicate data. Honestly,...

I don't have documentation on this kind of setup, sorry. I've never run more than 2-3 instances on a server.

However, heck yes, you need to have max memory set.

@jo-2 Pattyn...

One, please, always, despite this being a technical question, talk to someone in legal at your organization after you decide on a path forward.

Two, I've been studying this for years,...

ISNULL will affect performance if the ISNULL is being used in WHERE, ON or HAVING. As part of the SELECT or VALUES listing of columns, ISNULL won't be a big...

Thanks for the responses everyone.

Rod, I feel for you man. It's hard to find good places where you can learn & grow. I went through four jobs in less than...

I point to three tools for monitoring query performance (not Jobs, Johan's answer is a good one), including batches, statements and procedures. These are, in no particular order, Dynamic Management...

So just to clarify. if i have a clustered index on say contactid and invoiceid however none of the updates are on those columns then there wouldn't be a...

I like @DesNorton's answer.

However, what about just using the SEQUENCE object? It'll do the increments for you. It doesn't have to be specifically an IDENTITY column that way.

Got an email from Degreed.com giving me recommendations for virtual training and … well, apparently there are urgent SQL courses I need to take today and ...

Well, what do...

So, I work for Redgate, so any & all biases up front.

Nope.

Not for what you want. I've evaluated some of the SaaS monitoring tools that will monitor SQL Server. Frankly,...

When I run the same query multiple times why does the CPU time fluctuate between 0 and 16ms in tracer, query cost and live data explorer? Also I have...

You can use Extended Events to capture errors. This can include, if needed, the T-SQL statement or Object_ID of the query involved.