Viewing 15 posts - 61 through 75 (of 107 total)
SELECT
FK.name,
SCHEMA_NAME(FK.schema_id) AS...
January 18, 2018 at 11:05 am
Hi,
Great post. I thought I'd chime in with something that hopefully could help. My organization has a similar DimDate table. Upon taking a closer look, it's populated by...
January 9, 2018 at 10:07 am
January 9, 2018 at 9:14 am
January 8, 2018 at 10:58 am
Okay, so another questions for the experts out there....so as posted above, I'm in the process of attempting to optimize a crazy query, and I think I'm on a good...
December 22, 2017 at 11:14 am
Thank you for your feedback, Jeff. That was very helpful and I was finally able to use the "Persisted" option 🙂.
I am wondering though, if there's...
December 20, 2017 at 9:30 am
Hi Jeff,
Thanks for your reply. So upon looking into it further, the CoverageEffectiveDateKey is actually a foreign key that has been set to the INT datatype, which I traced...
December 18, 2017 at 9:45 am
Hi J Livingston SQL,
"CoverageEffectiveDateKey" is of the int datatype...it displays dates in the "yyyymmdd" format...it's actually a foreign key being used by several tables in the datamart here....
December 15, 2017 at 11:30 am
WHERE CASE
WHEN([CoverageLengthMonthNumber]=13 or[CoverageLengthMonthNumber] =25...
December 1, 2017 at 11:50 am
December 1, 2017 at 8:01 am
Hi Jeff,
Thanks for your reply. Yes, this code has been returning about 15 million rows...which seems to be the norm for the business here. The business users here...
December 1, 2017 at 7:46 am
December 1, 2017 at 6:14 am
Hi ScottPletcher,
Thanks for the suggestion....sorry I meant to reply to your earlier post. I will try changing the clustering and report back with the results. Thank you :-).
November 30, 2017 at 2:20 pm
November 30, 2017 at 8:59 am
November 30, 2017 at 8:58 am
Viewing 15 posts - 61 through 75 (of 107 total)