Viewing 15 posts - 541 through 555 (of 1,353 total)
2. RonKyle, I thought of just removing the NULL after but this now has a Primary ID of 1, which means any "real" data starts at ID 2. Is there...
October 27, 2015 at 7:04 am
Do you mean that it's importing a row consisting of entirely NULL values, or that when a certain field is NULL it shouldn't be imported? Is there a primary key...
October 26, 2015 at 1:17 pm
Often times I feel like a nutritionist working for McDonalds; I'm turned to for advice, but at the end of the day I have little influence over the end product.
Great...
October 26, 2015 at 9:53 am
RonKyle (10/23/2015)
That's perfectly fine. It relates to the individual record. Where's the denormalization in that?
You have two indicators for the same thing: the flag, and whether the date is null....
October 23, 2015 at 9:56 am
angel-626714 (10/23/2015)
I would also have a column for the date and time it became inactive.
Denormalisation alert
That's perfectly fine. It relates to the individual record. ...
October 23, 2015 at 7:56 am
I'm not sure I'm consistent. For items that are look ups of one kind or another (that would be considered dimensions in an OLAP environment), I use an Active...
October 23, 2015 at 4:53 am
Just adding that I've set up two SQL Server 2014 accounts using the Virtual Service Accounts that go with each service. They have worked very well and I would...
October 21, 2015 at 7:20 am
I've always had them on the same server, even large ones, and it's never been such as issue as to be worth having them on a second server. You...
October 19, 2015 at 1:40 pm
Good catch. It is probably trying to convert the semicolons to an int, which of course isn't possible.
October 19, 2015 at 9:33 am
One of the data points must not be a number or it's a number greater than a tinyint can handle (255 or 256--can't remember exactly which).
October 19, 2015 at 9:25 am
However, in my current use case, I keep all logic in the database. SQL Server is the BI platform. Everything is batch, everything is controlled by SQL Server.
I have been...
October 18, 2015 at 7:24 pm
There's data logic, process and workflow logic, and interface logic.
This is really a great way to break it out. If this were fleshed out, you might have an...
October 16, 2015 at 12:24 pm
This has always bothered me: What really is meant by "business logic"?
This is a good point, and someone else has also mentioned it. As you point out,...
October 16, 2015 at 7:56 am
While the final answer may depend on the skills that are available in-house. Also, if the application will never be large, it probably doesn't matter. But if you are...
October 16, 2015 at 5:06 am
Thanks for taking the time to write this. Took me way beyond what I've done with the OVER function.
October 14, 2015 at 8:17 am
Viewing 15 posts - 541 through 555 (of 1,353 total)