Reputation
1,695
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
7 24
Newest
 Organizer
Impact
~64k people reached

3h
answered New fact table or new dimension
Apr
17
answered Is it good or bad practice to have a fact table relate to the same dimension table multiple times?
Apr
17
answered Should I create a Factless Fact Table or Denormalise my table
Apr
16
comment When should I use a unique constraint instead of a unique index?
On MS SQL, they're implemented the same. Try creating two tables with the same data, one with a unique constraint, the other with a unique index. They will use the same amount of index space, and both will be able to seek against the unique index which (in practice) is created either way.
Apr
10
comment best ETL design to transfer transaction tables records into the data-warehouse
+1. I've used these techniques successfully on a small-to-medium-sized (10s of millions of records) warehouse. Note that you can also cap your loads; e.g., select the first X records ordered by the ROWVERSION field, so you know your ETL will never attempt to move more than it can handle. If the system falls behind for any reason, it's better to catch up gradually than to try to import more than it can handle and fail when your log file fills up.
Apr
10
answered How do you roll up header-level values on a fact table with line-item granularity?
Apr
10
asked Is there value in storing audit fields in a fact table?
Apr
9
comment Behavior of Varchar with spaces at the end
...and stackoverflow.com/questions/2025585/…
Mar
12
comment Which should I use on my DB? - Clustered Index or Non Clustered Index or Both
+1. Another reason to cluster on the date field (first; you may have other fields subsequent in the clustering key) is that dates are typically used for ranges. A range lookup on a clustered index is very efficient.
Mar
12
comment Is this MERGE statement correct?
No, you reference E14_LOAD, but I see no such table. That's a syntax error, which your SQL editor should call out for you. I'm not sure this is a DBA question.
Feb
27
comment Optimizing queries for 25+ million rows
So is the query you're trying to optimize for SELECT COUNT(*) FROM MyTbl WHERE Table = @X AND Field = @Y AND After = @Z AND Date BETWEEN @A AND @B? I agree with ypercube, if you can't add indices you're... very limited.
Feb
25
comment MySQL requires FORCE INDEX on huge table and simple SELECTs
What's the cardinality of Source? Are some values much more common than others, and are those the ones which run faster with the date index?
Feb
25
revised Should I use a compound or surrogate PK in a many-to-many table?
Added a more specific title, and trimmed the needless tag prefix in the title
Feb
25
suggested approved edit on Should I use a compound or surrogate PK in a many-to-many table?
Feb
25
comment Primary keys: composite and singular
To my astonishment, I cannot find an existing question on this topic on DBA. It is discussed on SO (stackoverflow.com/questions/107404/…), however.
Feb
24
comment How to reduce database size with BLOB fields
What exactly is the SELECT statement? Is there something stopping you from NOT including the BLOB field in your select list?
Feb
20
comment How can I invoke an SSIS package from SQL Agent, via T-SQL, using a proxy
Is it necessary that the SSIS jobs run through SQL Agent? I've done similar things, but used SQL Agent to launch my app, which in turn launched dtexec, called sprocs, performed file operations, etc.
Feb
20
comment SQL Server choose at random from giving data
This has been examined in detail on Stack Overflow (stackoverflow.com/questions/848872/…). Curiously, we don't seem to have the same question here on DBA yet though.
Feb
20
comment Order In WHERE Clause Matter For SARGability?
You can answer this for yourself by comparing the execution plans. If you'd like to post them, we can clarify for you how each plan is using specific indices.
Feb
18
answered How to efficiently create a new PRIMARY KEY CLUSTERED definition online