Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with data-warehouse
Search options answers only
not deleted
user 104717
A database system optimised for reporting, particularly in aggregate. Often, but not always implemented using a star schema.
5
votes
Accepted
Scripts to disable constraints and indexes for data warehouse load
For a few things that you may have not considered:
If an index starts as disabled you'll end up rebuilding it after your script finishes.
If an index starts with page compression you'll rebuild it w …
- 32.6k
3
votes
Accepted
EDW index question
This can easily be done in SQL Server 2016. You can create nonclustered rowstore indexes and one nonclustered columnstore index on a table even if that table already has a clustered rowstore index.
T …
- 32.6k
7
votes
Accepted
Where should I put nvarchar(max) dimensions in my data warehouse?
Microsoft recommends using a CCI for large data warehouse tables with a few caveats including:
Don't use a clustered columnstore index when:
The table requires varchar(max), nvarchar(max), or varbin …
- 32.6k
12
votes
Accepted
When are dimension tables still needed using clustered columnstore indexing?
I don't think that your question is applicable to any RDBMS that supports columnar storage. I'm writing my answer from the point of view of SQL Server and most of the reasons depend on implementation …
- 32.6k