Viewing 15 posts - 1 through 15 (of 598 total)
Thanks Jo.
I'm residential (local SAN - on premise) no cloud.
So the current recommendation is to not even do rebuilds?
August 8, 2024 at 4:49 pm
ended up writing the results to a table in a different DB via a job and granted access to that table. works fine.
July 30, 2024 at 1:40 pm
Ahh great catch Jeffery! Much thanks!!
February 5, 2024 at 9:51 pm
ahh persisted...hmm its not used that much so maybe overkill for this.
I like the two left joins - trying that now.
Thanks Phil - appreciate the help!
February 5, 2024 at 5:12 pm
Kinda yeah - feel my pain
I know there is a translate function that can sometimes be used in place of 'replace' but I'm on v120. So no easy way out...
February 5, 2024 at 4:19 pm
Yeah I tried the try cast - didn't work.
I just removed the formatting - fine for now.
Thanks guys!
January 19, 2024 at 12:55 pm
this works - but I loose the formatting
SELECT
DISTINCT
provTaxID
,provNPI
,provName
,provShortName
,'https://npiregistry.cms.hhs.gov/registry/provider-view/' + provNPI BillProvURL_NPPES
...
January 18, 2024 at 10:11 pm
I think I just may be stuck with "it is what it is" - I know its a ton of records. Really just wanted to make sure I tried everything...
January 5, 2024 at 3:50 pm
Sure, logical assumption and my fault for not specifying
It returned in same time..
January 4, 2024 at 9:15 pm
Thanks Jonathon.
Thanks Brian - yeah that table gets massive inserts and updates so I guess indexed view is a bad option.
Tried using exists - same run time:
select...
January 4, 2024 at 6:15 pm
Trying to index the view
--Set the options to support indexed views.
SET NUMERIC_ROUNDABORT OFF;
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,
QUOTED_IDENTIFIER, ANSI_NULLS ON;
--Create view with SCHEMABINDING.
IF OBJECT_ID ('dbo.FastEligibilityView',...
January 4, 2024 at 3:41 pm
Jeff
the query is the slow part of a larger process.its not being posted to a screen - query is part of universe of claims process that needs to look at...
January 4, 2024 at 12:34 pm
Thanks!
December 14, 2023 at 5:52 pm
Thanks Ant-Green. Kinda figured that.
I have an A,B servers. Sys admins want to move the B server to the new location on one weekend and server A the following weekend.
Assuming...
December 13, 2023 at 7:32 pm
Viewing 15 posts - 1 through 15 (of 598 total)