Viewing 15 posts - 466 through 480 (of 1,353 total)
That's the reason of why I didn't include them in the examples
I see your point now. You're right.
August 22, 2016 at 8:57 am
The next part of the discussion should have been around the encryption of SSNs.
We were designing for a SQL 7 database (this was in the late 90s) and I was...
August 22, 2016 at 8:31 am
If there is no need for someone to have access to all the records, my recommendation would be to break this out into separate cubes for each client. That...
August 22, 2016 at 8:00 am
If the same product has multiple colors and sizes, then obviously you will have redundant data for ProductName. You may want to address that by splitting out color and sizes...
August 22, 2016 at 7:55 am
Also, use numeric data types when appropriate (FYI, telephones and zip codes are not numeric data).
Social Security numbers are also not numeric. Once had a discussion with a...
August 19, 2016 at 8:34 am
This is also why I don't let "developers" do database design unless they've been trained to do it right
Unfortunately not everyone has that luxury. It doesn't help that they...
August 18, 2016 at 8:31 am
Interesting! Thank you for the kind response! I'll use varchar(8000) from now on.
Adding to the voices urging you to ensure your number choice is correct for the data. ...
August 18, 2016 at 7:23 am
This was a good question, but I would have pushed off the NULLS until another day, especially in a multi select answer. It added a level of complexity for...
August 18, 2016 at 7:10 am
I would tell my kids that "Family comes first, but not always." There would be times in life where work temporarily came first. Had it remained permanently so,...
August 11, 2016 at 7:26 am
I don't know this will help your speed issue, but consider not doing the conversion between the file and the landing table. Your first job is to just get...
August 8, 2016 at 8:10 am
I would not recommend a junk dimension for such a large combination of items. I've used these a few times for a few combinations of yes/no, and once for...
July 19, 2016 at 5:44 am
For every far off idea that now seems a reality, there are many that remain a far off idea. When doing historical research for my master's thesis, I remember...
July 8, 2016 at 9:12 am
To paraphrase what is said about fusion energy, this seems in the future, and always will be. Given that wizards for basic things aren't quite as good as humans,...
July 8, 2016 at 6:12 am
It's a simple join, but it's still additional work for the developer and the server
Doing the date the other way takes constant work for the servers. It's not as...
July 1, 2016 at 11:13 am
I don't like that idea because that way you need to join tables for simple queries restricted by dates.
To that I always reply that no user should be looking at...
July 1, 2016 at 9:11 am
Viewing 15 posts - 466 through 480 (of 1,353 total)