Orlando Colamatteo (1/30/2016)

I could...

The return value of a function is the literally just value that it returns when run.

SELECT ISNULL(1, 2) -- returns 1, because the first parameter is not null

SELECT ISNULL(NULL,5) --...

Kinda makes sense. You may gather that I barely use MERGE. I think the last time I wrote one was when I was teaching a class on T-SQL commands.

Hugo Kornelis (1/30/2016)

True on SQL...

You don't need both of these, they're checking for the same thing.

IF @@ROWCOUNT = 0

RETURN;

IF NOT EXISTS (SELECT * FROM INSERTED) RETURN;

The login that the access app is using can no longer connect to the DB db2. Either:

- The DB is no longer there

- The DB cannot be opened

- The login...

You don't need to rebuild the indexes, doing so is a massive waste of time. Fragmentation's not the problem. The stats are out of date, that's the problem.

You didn't even try to run that...

Go back and look at Hugo's example of an...

I think you get exactly what you asked for with that. The test of the most recent batch run on that session, as per c.most_recent_sql_handle. No, it's not random, or...

Why don't you take this as an opportunity to get better? Hugo explained what's needed, and I'm sure he'll fix errors if you try...

The cause of the problem is that the database named "db2" is either no longer on that instance, or can't be opened or the login no longer has permission to...

If SQL said that procedure was the cause of the blocking, then it was the cause of the blocking.

150 commands and 3 minutes is insane for a transaction. Does...

ReadUncommitted doesn't mean no locks. It means that selects don't take shared locks (and that your results can be quite inaccurate due to rows read twice or not read at...

Is it me, or are there weird threads again today. "I want the challenge of trying to fix it without using the easy way" says one, and a second berated...

Oh, hell, yes. SSMS intellisense...