More like

declare @StartDate datetime,

@EndDate datetime;

set @StartDate='2016-09-01';

set @EndDate='2016-09-30';

--Get inpatient VisitID's to look up

selectHRVD.SourceID,

HRVD.VisitID,

PADQ.*

from livefdb.dbo.HimRec_VisitData HRVD

inner join livefdb.dbo.PcsAssmntData_Queries PADQ

on HRVD.SourceID=PADQ.SourceID

and PADQ.PcsAssmntDataID = <fill this in>

where HRVD.SourceID='BRO'

and HRVD.VisitType_MisRegTypeID='IN'

and HRVD.RegistrationDateTime>=@StartDate and HRVD.RegistrationDateTime<dateadd(day,...

You're looking at a join there, not a 'passed value'.

FROM from livefdb.dbo.HimRec_VisitData INNER JOIN livefdb.dbo.PcsAssmntData_Queries ...

Same. I'm always going to be poking fun at something in a presentation (in the one I did this...

Sure, because then it'll be

PcsAssmntDataID = @SomeValue + '{A^GEN.ADMPART2}', and that's SARGable.

RIGHT should give you exactly the same results and performance. The clustered index order is not ideal for that query, but might be hard to change (you'll have to make...

Rehearse the presentation. To the wall, to your pets, to a willing victim. Doesn't matter, just make sure you run through it a few times.

Enterprise edition can use OS maximum of memory, so more than you have.

What do you mean by "it looks like SQL Server can't use more than 32GB of RAM"? What...

Have you tested that thinking out and confirmed it? If not, do some tests before...

No. The destination schema must match the origin schema (can be hacked, I've done it, caused unending pain).

These tables are on different servers?

For me, sorry I thought the second paragraph would have made that clear.

Also, sorted enough. Got some stats from SQLCat and a few other places, and got enough examples to...

Reposting from twitter:

"I'm looking for examples of extremely big or extremely busy relational database systems doesn't have to be SQL Server."

Case studies or similar, don't need detail, just

It's for...

You have the latest SSMS 2016?...

It does (try it, you'll end up with @@TRancount of 1), because of deferred compile.

When the batch is parsed, the table...

Several days spent reading up on the feature (as it's not simple) and a test environment where you can practice.

It's a parse error and try-catch cannot catch parse errors.