1,331 reputation
621
bio website
location Austin, TX
age 33
visits member for 3 years, 3 months
seen 15 hours ago

22h
comment SQL Server Real Time Data integration with different Instance
I'm not sure this is answerable without more information. 100s of transactions is nothing, if they're sales records or something, a few hundred bytes each. If each "transaction" is 10 GB of scientific data, then you have a problem. Is the real question "are triggers the best way to handle real-time ETL across MS SQL instances on the same server?"
1d
comment Sql Server 2012 data warehousing and different versions
This information holds for SQL Server 2014, with one noteworthy (IMHO) addition: 2014 EE includes Attunity drivers for SSIS, which are supposed to dramatically increase throughput with Oracle databases. Also, in 2014 the memory limit for Standard and BI editions was increased to 128 GB.
Aug
15
comment Select rows where 2 cells not the same
Note that you may well get an id from one record and an AEN from another. E.g., "{3, 103, white, ...114}" (you wouldn't get that exact value, but unless id and AEN sort identically there will be instances of conflict).
Aug
12
awarded  Notable Question
Aug
11
comment Should I use conventional or computed columns for trivial metrics in a fact table?
Agreed, I'm just throwing it in there. Agreed again, it's less data to read. Sure, end tools have their own ways to account for this kind of thing, but I find there's usually at least a little business logic - e.g., the "N/A" customer should have a zero for NumCustomers - which I'd like to model at the lowest possible level.
Aug
11
comment An advice to design a fact table with a scd as a dimension
Tasks is a fact table, not a dimension, so it can't be an SCD. Status is a dimension, and a slowly-changing one at that. Though in some cases it may be maintained as just an attribute of the fact table, meaning a simple VARCHAR field, rather than an FK out to an explicit dimension table.
Aug
11
comment Fact table foreign keys null?
I agree, but for the reason cited by Brown: it's very valuable to have explicit synthetic records for the reason the field would otherwise be NULL. NULL tells users nothing; "Value could not be parsed", "Field left blank", or "No account executive assigned yet" is useful.
Aug
11
asked Should I use conventional or computed columns for trivial metrics in a fact table?
Aug
8
comment Can MySQL reasonably perform queries on billions of rows?
+1 for actually explaining why a NoSQL option may be effective.
Aug
6
answered Should I drop a foreign key if I use a soft delete?
Aug
6
comment Last few rows from a non-indexed table in Oracle
How much freedom do you have on the MS SQL end? You could query the relevant records and cache them in a temp table on the MS SQL side, and join to that instead.
Aug
1
accepted What is the distinction between ALL_PROCEDURES and DBA_PROCEDURES, and other schema tables?
Jul
31
answered Table design for child tables with multiple many-to-many relationships
Jul
31
comment Table design for child tables with multiple many-to-many relationships
A subnet has one network, one location, zero or more other subnets, zero or more VLANs, and zero or more VPLSs; is that right? And the same for VLANs and VPLSs?
Jul
29
comment Datawarehouse Design: Combined Date Time dimension vs. Separate Day and Time dimensions and timezones
@MattPalmerlee: Users can group by time zone if you give it to them. I'd typically include it in the Geography table, but if none applies you can add it as an attribute of your fact table.
Jul
29
comment Datawarehouse Design: Combined Date Time dimension vs. Separate Day and Time dimensions and timezones
This question also exists in Stack Overflow: stackoverflow.com/questions/2507289/….
Jul
29
comment What happens during “big” inserts on a table with a clustered composite key?
+1 for a great simple illustration of fragmentation. +1 for the rest of the answer too!
Jul
25
comment SQL ANSI JOIN precedence
Mixing LEFT and RIGHT JOIN in the same query is begging for confusion, IMHO.
Jul
15
comment How can I control the order of a query regarding to inner join
The RDBMS will optimize the join order, and usually does so more intelligently than any but the most skilled DBA. As Michael Green implies, join order is almost certainly not the real problem.
Jul
2
awarded  Curious