The pass mark for these is around 70%, so if the second half was worth more than the first, the failure is understandable. What was your mark, if you don't...

You should have got a print out from the exam center showing you a breakdown of the exam by categories, and a graph for each of those categories showing how well...

In that case, I would leave 1 GB for the OS. This is assuming there's nothing else running on that server. Make sure that the SQL Service account has permission...

Depending on the plan that the optimiser comes up with, SQL may run the cast and filter before it runs the isnumeric filter. Short of plan hints, there's little way...

Be careful with IsNumeric. It returns true for some values that cannot be converted to int.

SELECT

ISNUMERIC('1,234.00'),

Stupid questions, I know, but have you checked to make sure that

1) The table is there

2) The name is spelt correctly

3) It's in the dbo schema

4) If your db is...

Your trigger is assuming there's only one row inserted. If there's more than one, the not exists could return true (for 1 of the records) but on another there's a conflict.

Try...

I'm not a network expert either. You might have to do a DNS lookup from the command prompt, using xp_cmdshell, then parse the results of that.

You could try ping....

What you can try, as a last resort, is to add WITH (ROWLOCK) to the update statement. I don't normally suggest hints as SQL usually does a good enough job...

A case statement in SQL can only be used within a select/update statement. It can't be used for control flow in the procedure. For the latter, use IF statements.

The form...

The lock requests are on a RID. That's not possible if there's a clustered index on the table in question. RIDs (Row Identifiers) only exist in heaps.

Can you post the...

See if you can get traceflag 1204 switched on. That outputs the details of the deadlock to the error log, including both nodes and what resource they were deadlocked on.

If...

SELECT @@Servername and SELECT serverproperty('MachineName') will get you what SQL thinks the machine name is. Typically, this is the name the machine had when it was installed, though it can be...

Ah, so it's an auto-generated query.

A transaction is not considered one statement, and you're right, the CTE would be gone by the second select. Since this is auto generated, try...

Perhaps insert the subquery portion into a temp table (or use a CTE), then you can use that in the outer query and again to get the rowcount.