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.
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
1
comment
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
8
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
Sorting a Hierarchy differently
Mark Chinsky
1
comment
0
votes
None
Format standard measure to hh:mm format.
Jyothi Dosi
2
comments
0
votes
None
Custom Data on a table
Padarthi, Satish
1
comment
0
votes
None