Business Intelligence

Oracle Disable Indexes and Constraints During Insert

If you are attempting to insert millions of rows into an oracle database, you may want to temporarily disable indexes and constraints to improve the speed of the load. Here are 5 steps to follow that will disable constraints and make indexes unusable. You need to substitute the OWNER and TABLE on line 5 and 6 respectively in each statement. 1. Disable Constraints 1 2 3 4 5 6 7 8 9 10 11 BEGIN FOR cur IN (SELECT OWNER, CONSTRAINT_NAME , TABLE_NAME FROM all_constraints WHERE OWNER = 'OWNER' AND TABLE_NAME = 'TABLE') LOOP EXECUTE IMMEDIATE 'ALTER TABLE '||cur....

February 19, 2012 · John Levandowski

Blackjack Basic Strategy - Double After Split

If double after split (DAS) is available, you should split pairs more often to take advantage of this rule. Here are updated rules for pair splitting when double after split is available. 7 blackjack basic strategy rules for pair splitting (DAS allowed): Always SPLIT A’s and 8’s NEVER split 5’s or T’s SPLIT 2’s and 3’s vs. dealer 2 thru 7 SPLIT 4’s vs. dealer 5 or 6 SPLIT 6’s vs dealer 6 or less SPLIT 7’s vs dealer 7 or less SPLIT 9’s vs dealer 9 or less, except STAND vs dealer 7 Here is the relevant update to the pair splitting section of the basic strategy card for when double after split (DAS) is available....

June 15, 2011 · John Levandowski
Blackjack

Blackjack Strategy Card

Learning how to play blackjack using a basic strategy card is relatively easy given the willingness to do so. Basic strategy is the optimal set of rules to follow for playing blackjack. Using simple basic strategy you will cut the house advantage for blackjack to about 0.50%. A simple blackjack strategy card is often used for memorization and as a reference at the tables when allowed by the casino. You should use a blackjack strategy card to make decisions on playing each hand in the following order: Insurance Pair Splitting Double Down (look for soft hands first) Standing (look for soft hands first) 2 rules for insurance: NEVER take Insurance NEVER take Even Money when you have a blackjack, it is the same as insurance 6 rules for pair splitting: Always SPLIT A’s and 8’s NEVER split 4’s, 5’s, or T’s SPLIT 2’s and 3’s vs....

April 11, 2011 · John Levandowski
2009 Trek 2.1

Apple Cider Century 2009

In 2009 I purchased my first road bike. 2009 was also the first year I specifically trained for a cycling event. My goal was to complete 100 miles in the Apple Cider Century. As you can see, I came a little short of my goal distance and only finished about 71 miles of the event. However, this was the longest I have ever bicycled in one day.

September 28, 2009 · John Levandowski
2009 Trek 2.1

Amishland and Lakes 2009

The Amishland and Lakes bike tour is a 2 day cycling tour of Amish countryside and Michigan lakes hosted in Howe, Indiana. In 2009 I participated in this event and completed 97 miles of cycling over a 2 day period. This is the longest (in miles and time) that I have spent on a bicycle over a 2 day period. Day 1 - Amish Countryside Day 2 - Michigan Lakes

August 10, 2009 · John Levandowski