Viewing 15 posts - 946 through 960 (of 8,731 total)
October 2, 2017 at 10:10 am
September 29, 2017 at 11:18 am
September 29, 2017 at 8:53 am
exec...
September 28, 2017 at 12:01 pm
September 28, 2017 at 9:35 am
Apparently, we got an Oracle fan that likes to resurrect things, like 7 year old threads or his 7 year old account.
September 28, 2017 at 9:08 am
The first query is simulating an aggregate function. It's not returning all rows, just one for each customer. The second query will return one row per order.
You don't need...
September 28, 2017 at 8:51 am
September 28, 2017 at 8:43 am
Then, the first thing you need to practice is how to generate sample data that is large enough to test for performance.
Here are 2 articles that can help you...
September 28, 2017 at 8:40 am
I am starting to work in an environment where database DevOps plays a very...
September 28, 2017 at 8:12 am
Oracle is always best and better than SQL server. When come to data warehouse...
September 28, 2017 at 8:10 am
September 28, 2017 at 6:49 am
EDIT: Disregard, I misunderstood.
If that's for reporting, I suggest that you do it on the front end.
However, here are 2 articles that can show you the path...
September 27, 2017 at 1:30 pm
We had a guy in here a few years ago who wrote a...
September 27, 2017 at 8:16 am
Neither database, nor code design first. You need to have a logical design which would include a correct ER design.
Skipping this step will only give headaches when trying to...
September 26, 2017 at 1:02 pm
Viewing 15 posts - 946 through 960 (of 8,731 total)