Viewing 15 posts - 511 through 525 (of 1,353 total)
I'm with Sean. I would absolutely normalize this data.
This is a false choice. The question is not to put it in a single table in an unnormalized format...
March 3, 2016 at 1:07 pm
But if you keep this in one table you lose a lot of data integrity control from the database side. You now have to allow null and move the RI...
March 3, 2016 at 10:15 am
think you will be much happier in the long run if you break this into properly normalized tables
In the absence of data, this cannot be determined with certainty. ...
March 3, 2016 at 8:46 am
This can't be answered with certainty in the absence of data. However, there is nothing offhand wrong with this. I'm assuming that the IDs point to other tables....
March 3, 2016 at 7:55 am
Also, I would like to know how many people would have selected NULL if that had been an option.
I would have selected that. I was actually going to...
February 18, 2016 at 12:00 pm
Nice article. Really like combining it with the REPLACE function.
January 15, 2016 at 5:33 am
I don't understand why you are relying so heavily on this New_Player flag, when the new player logic seems so straightforward.
Agreed. This violates that rule that fields depend on...
January 5, 2016 at 2:03 pm
As the issue is resolved and I know what to look for the next time, and I have more than enough to do, going into Sherlock Holmes mode would not...
January 4, 2016 at 1:36 pm
Are you sure that the connection string you were 'using in the package' was not being overridden by a config item (eg, an Environment Variable)?
Yes, I'm sure. I...
January 4, 2016 at 1:14 pm
Post is a little old, but I ran into this issue and the solutions offered didn't help me. So in the event someone else runs across this and the...
January 4, 2016 at 12:57 pm
If the SQL 2000 point was skipped, the next response would have been "Hey, your code sucks because it doesn't work on my SQL 2000 instance."
A good point. Maybe...
December 28, 2015 at 7:16 am
That's a pretty jerk answer.
Sorry, but I don't agree. Maybe it could have been phrased differently, although I don't see anything wrong with it. But the help...
December 24, 2015 at 2:53 pm
It would be helpful to know what version you are using. I've recently done some SQL Server 2014 installations and have found the managed service accounts to be wonderful....
December 24, 2015 at 2:50 pm
This just sounds like a straight INSERT into a fact table of new rows, after having populated all associated dim tables. It would be fast. But how does it handle...
December 22, 2015 at 8:24 am
That's just a wild guess though based on what he said.
That's pretty wild. Not it, though. I'll post tonight or tomorrow. I need to screen a...
December 20, 2015 at 3:21 pm
Viewing 15 posts - 511 through 525 (of 1,353 total)