Viewing 15 posts - 406 through 420 (of 1,353 total)
You don't blindly say "Never use identities" any more than you would say "Always use identities" for keys.
I would never say either of those statements. But as some...
December 28, 2016 at 9:07 am
It can be used. But there could be fragmentation if new accounts are added in some patterns, rather than in (generally) increasing values.
For example, suppose the first 3 characters of...
December 28, 2016 at 7:38 am
Do you have any idea, can we call three SP in one package to generate 3 DIFFERENT files?>
Yes, you can. You will need three different Excel connections to do...
December 28, 2016 at 7:17 am
I've found that account numbers (of various types, not just bank accounts) have meaningful leading zeros. So they must be stored as char/varchar.
Excellent point. However, why can't that...
December 28, 2016 at 7:02 am
I use a column check to clear the records before going forward. It does mean that I have to know the things that can go wrong, and occasionally there...
December 27, 2016 at 9:59 am
Would using UserID column (GUID) or BankAccount column (9 digit integer) as the primary key column be less efficient than using an ID column of type integer which auto increments?...
December 26, 2016 at 7:08 pm
There is nothing wrong with nvarchar/nchar fields. Unless you look at all the double operations that must occur, and the extra disk space required to store as nvarchar/nchar.
This is...
December 15, 2016 at 8:33 am
I work with overseas (Non-US) data and have to remove some of the accents/extended chars due to the way OLAP is configured to work (US Only).
I don't understand this....
December 15, 2016 at 8:19 am
While the article doesn't explain the context of the data move, if it's the start of a BI ETL, I think it's better to make the landing table match the...
December 15, 2016 at 7:52 am
You can create the calculated member as a null only value, and the use a SCOPE statement so that it only shows up when desired. Hopefully you know some...
December 14, 2016 at 1:19 pm
Maybe we need some clarification on what you mean by multiple data warehouses? In general, a data warehouse can consist of multiple fact tables, each of which relates to multiple...
December 12, 2016 at 11:52 am
I think it is a good idea to keep the business ID along with your surrogate key definitely.
Strongly agree with it in the fact table. Unsure what you meant...
December 9, 2016 at 11:21 am
1. You can run the exact same package simultaneously. What you can't do is execute a job while it's currently running. I can set up a job to run package...
December 8, 2016 at 10:22 am
SSN as a key would be probably a good choice
Using an SSN as a key is never a good idea, except perhaps for the Social Security administration. The number...
November 29, 2016 at 2:35 pm
Any idea what the breakdown was for such employee "numbers" was? Did they base them on some sort of date and sequence number combination? or ???
There have been multiple...
November 28, 2016 at 10:13 am
Viewing 15 posts - 406 through 420 (of 1,353 total)