Reputation
256
Top tag
Next privilege 300 Rep.
Create new tags
Badges
2 8
Newest
 Tumbleweed
Impact
~7k people reached

  • 0 posts edited
  • 0 helpful flags
  • 11 votes cast
Apr
21
comment Clustered index on a fact table
But wouldn't the choice of clustered index affect a MERGE as well?
Apr
21
asked Clustered index on a fact table
Mar
15
accepted How to start indexing a new data warehouse
Mar
8
comment How to start indexing a new data warehouse
Thanks, John -- lots of good stuff in there!
Mar
6
asked How to start indexing a new data warehouse
Mar
6
accepted What to name a field that includes Store and Version ID
Feb
25
asked What to name a field that includes Store and Version ID
Nov
5
awarded  Tumbleweed
Oct
29
asked Design for a multi-tenant multi-version database
Oct
7
accepted When to run ETL for dimensions
Sep
21
awarded  Curious
Sep
17
comment When to run ETL for dimensions
Yes, we do! We could use those to only update the changed rows -- is that what you are suggesting?
Sep
17
comment When to run ETL for dimensions
if we loaded all the dimensions, then it would take too long. If we had a technique for only loading definitions that had changed, it would load quickly and we could load on a schedule
Sep
17
asked When to run ETL for dimensions
Feb
12
awarded  Nice Question
Feb
12
awarded  Yearling
Jan
15
revised Backup and FTP SQL Server databases
added option #4 ("find new FTP software...")
Jan
14
revised Backup and FTP SQL Server databases
changed title
Jan
14
comment Backup and FTP SQL Server databases
@RLF I agree, so I would copy the files instead of move them to a single folder
Jan
13
asked Backup and FTP SQL Server databases