Viewing 15 posts - 226 through 240 (of 1,353 total)
Not replying directly to your question. But your table design on the face looks very suspect with the repeating groups of fields. This would normally result in a great number...
April 18, 2018 at 7:21 am
Don't use Null. Assign it to an "Unknown" bucket. I do a left join on the dimension tables for the load into the fact tables with a COALESCE statement. If...
April 12, 2018 at 3:30 am
I think they are bundled. SSAS and SSIS and SSRS are separate services and subsystems. I can run SSAS without running the core db engine.
No doubt technically. ...
April 10, 2018 at 12:51 pm
It's not that BI is a bad thing, but I thought the focus of this discussion was SQL Server. There just happens to be a number of things...
April 10, 2018 at 11:26 am
2012 was mainly about BI.
You say that like it's a bad thing....
April 10, 2018 at 9:14 am
My choices reflect heavy use of ETL for data warehousing: SQL 2005 for the introduction of the Unified Dimensional Model in SSAS. Significantly if not radically changed the development of...
April 10, 2018 at 7:25 am
I've never done a named instance installation before, so I'm going to bow out.
April 6, 2018 at 9:03 am
I haven't done a 2017 installation, so something may have changed. But I'm surprised to see the Analysis Services service not running under "NT Service\MSSQLServerOLAPService." This is the managed service...
April 6, 2018 at 8:14 am
I have done several experiments to try to resolve this and am unable to. Either a key piece of information is missing, or it's that it isn't possible to do...
April 4, 2018 at 12:47 pm
Yep, yep! Unfortunately many SSIS Developers I have worked with come from .NET and procedural programming backgrounds and are unaware of what SQL Server does well.
That...
April 4, 2018 at 12:35 pm
TOPAS is a COBOL structure requiring quite a bit of string manipulation. Until SQL Server can handle ORC & Parquet files I have to use code to read...
April 4, 2018 at 11:30 am
It is not uncommon that the culprit is poorly designed transformation inside the ETL that can be done more efficiently in SQL Server.
I do not understand...
April 4, 2018 at 5:34 am
This is a really interesting discussion. I do all my work via ELT - load the data from files into SQL Server staging tables, then transform as it...
April 3, 2018 at 8:29 am
Covering the += operator might have been a nice way of demonstrating whats [sic] happening.
Is this better than the CONCAT function? I use that exclusively now for...
April 3, 2018 at 7:57 am
You don't have to worry about no rows.
The row count acts as a kind of error handling. I only use these when there should be...
April 2, 2018 at 8:54 am
Viewing 15 posts - 226 through 240 (of 1,353 total)