Viewing 15 posts - 2,311 through 2,325 (of 49,571 total)
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,...
September 29, 2016 at 6:15 am
You're looking at a join there, not a 'passed value'.
FROM from livefdb.dbo.HimRec_VisitData INNER JOIN livefdb.dbo.PcsAssmntData_Queries ...
September 29, 2016 at 5:59 am
Grant Fritchey (9/29/2016)
Personally, I can't help it, I go for humor.
Same. I'm always going to be poking fun at something in a presentation (in the one I did this...
September 29, 2016 at 5:45 am
Sure, because then it'll be
PcsAssmntDataID = @SomeValue + '{A^GEN.ADMPART2}', and that's SARGable.
September 29, 2016 at 5:33 am
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...
September 29, 2016 at 5:21 am
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.
September 29, 2016 at 3:27 am
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...
September 29, 2016 at 3:26 am
homebrew01 (9/28/2016)
The thinking was a denormalized flat file, with indexed columns would give fast search results.
Have you tested that thinking out and confirmed it? If not, do some tests before...
September 28, 2016 at 12:33 pm
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?
September 28, 2016 at 12:11 pm
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...
September 28, 2016 at 11:53 am
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...
September 28, 2016 at 8:52 am
Phil Parkin (9/28/2016)
So I checked Tools/Options/Query Execution/SQL Server/Advancedand see that I have
SET XACT_ABORT
checked ... so that was doing the sweeping up for me.
You have the latest SSMS 2016?...
September 28, 2016 at 8:16 am
Phil Parkin (9/28/2016)
The code does not even run.
It does (try it, you'll end up with @@TRancount of 1), because of deferred compile.
When the batch is parsed, the table...
September 28, 2016 at 7:51 am
Several days spent reading up on the feature (as it's not simple) and a test environment where you can practice.
September 28, 2016 at 7:21 am
It's a parse error and try-catch cannot catch parse errors.
September 28, 2016 at 7:20 am
Viewing 15 posts - 2,311 through 2,325 (of 49,571 total)