Questions around Table & Schema Design, Facts vs Dimensions, Data transformations, Lookups, Table Inserts, Add Related Records, Hierarchies, Pivoting Data, Primary Keys, Relations, Bridge Tables etc.
Solutions for different schemas in a data lake?
Brandon Spencer
6
comments
0
votes
None
Converting int/char to date
Gediminas
6
comments
0
votes
Completed
Incremental Table insert - Is it possible?
Bas Hopstaken
2
comments
0
votes
Answered
Relationship between 2 tables (left outer join)
Roland Peeters
1
comment
0
votes
None
Default column value for simple tables in BU / ODX Server
Ben van der Helm
5
comments
0
votes
None
Add related records, no relation between tables
Martin Larsson
3
comments
0
votes
None
Primary key violation - which record is then valid ?
Torben Kylling Petersen
1
comment
0
votes
Completed
Deadlock on sys.tables
Josiah Norton
9
comments
0
votes
None
Working with Table Inserts
Greg Laymon
2
comments
0
votes
Answered
Partition Scheme
Anders T. Grønlund
3
comments
0
votes
None
converted to type nvarchar
Rajneesh Mangotra
2
comments
0
votes
None
Table classification
Alexander Hauenstein
3
comments
0
votes
Answered
Clustered columnstore index
Per Scheffer
2
comments
0
votes
None
Two datasources into one table
Keith Williams
7
comments
0
votes
None
Setting a flag when execution is done
Michael Vaisgaard
2
comments
0
votes
None
Use IS NOT NULL as a join condition on lookup
Mark Ferris
15
comments
1
vote
None
CASE WHEN
Michael Vaisgaard
2
comments
0
votes
Answered
Securing sensitive data
Eric van Gemert
0
comments
0
votes
None
Can you protect your project from piracy?
Mark Chinsky
4
comments
1
vote
None
SQL 'Case'
sai krishna mamidi
1
comment
0
votes
None
Normalizing table containing filed in json format
Hansen, Mikkel Hecht DK - NOH
1
comment
0
votes
None
database diagram: visualize your data model
Dror Svartzman
6
comments
1
vote
None
Many to many Relations and condinonal joins
José Hoyos
3
comments
0
votes
None
Filtering on the Look up fields
Banerjee, Supriyo
4
comments
0
votes
None
Using Collate on Join conditions
Banerjee, Supriyo
4
comments
0
votes
None
How to RoundUp or RoundDown Decimal
Ghazy
2
comments
0
votes
None
Conditional Lookup multiple values
Hendrik Gruß
1
comment
2
votes
None