Weekly Round-Up: 9/1/13 to 9/7/13

The Weekly Round-Up is a once weekly collection of my #1Aday daily shares. Hope you find something of interest!

Tue 9/3
Leo @zen_habits tell you about The Thinking Habit That Changed My Life – http://markjacobsen.net/l/1855

Wed 9/4
David @DavidDCain does An interview with The Man – http://markjacobsen.net/l/1856

Thu 9/5
MMM @mrmoneymoustache reminds us that Luxury is Just Another Weakness – http://markjacobsen.net/l/1857

Fri 9/6
Joshua Fields Millburn @JFM on What It Feels Like to No Longer Worry About Money – http://markjacobsen.net/l/1858

Weekly Round-Up: 8/25/13 to 8/31/13

The Weekly Round-Up is a once weekly collection of my #1Aday daily shares. Hope you find something of interest!

Tue 8/27
Leo @zen_habits – My Advice for Starting a Business – http://markjacobsen.net/l/1851

Wed 8/28
Joshua Fields Millbur @JFM on The Worst Thing That Could Happen – http://markjacobsen.net/l/1852

Thu 8/29
5 reasons to place your marriage as top priority – http://markjacobsen.net/l/1853

Fri 8/30
Glennon Melton on: The Talk – http://markjacobsen.net/l/1854

Weekly Round-Up: 8/18/13 to 8/24/13

The Weekly Round-Up is a once weekly collection of my #1Aday daily shares. Hope you find something of interest!

Mon 8/19
Happily Ever After: How to Stay Married for 29 Years (and Counting) – http://markjacobsen.net/l/1846

Tue 8/20
15 Things You Need to Give Up if You Want to Be Happy – http://markjacobsen.net/l/1847

Wed 8/21
MMM @mrmoneymustache on: The Surprising Effect of Small Efforts over Time – http://markjacobsen.net/l/1848

Thu 8/22
Are You Stressed, Rushed, and Aggravated? – http://markjacobsen.net/l/1849

Fri 8/23
Saving 2 Hours Per Work Day is Easy! – http://markjacobsen.net/l/1850

Weekly Round-Up: 8/11/13 to 8/17/13

The Weekly Round-Up is a once weekly collection of my #1Aday daily shares. Hope you find something of interest!

Mon 8/12
jlcollinsnh – Stocks — Part XVIII: Investing in a raging bull – http://markjacobsen.net/l/1841

Tue 8/13
Liz Rivera on: Why You Should Revisit Your Five Year Plan – http://markjacobsen.net/l/1843

Wed 8/14
Jeff Haden on: 8 Things You Shouldn’t Do Today – http://markjacobsen.net/l/1844

Thu 8/15
Don’t Be a (Work) Hero – http://markjacobsen.net/l/1845

Weekly Round-Up: 8/4/13 to 8/10/13

The Weekly Round-Up is a once weekly collection of my #1Aday daily shares. Hope you find something of interest!

Mon 8/5
jlcollinsnh – Stocks — Part XII: Bonds, and a bit on REITS – http://markjacobsen.net/l/1836

Tue 8/6
jlcollinsnh – Stocks — Part XIII: Withdrawal rates, how much can I spend anyway? – http://markjacobsen.net/l/1837

Wed 8/7
jlcollinsnh – Stocks — Part XIV: Deflation, the ugly escort of Depressions. – http://markjacobsen.net/l/1838

Thu 8/8
jlcollinsnh – Stocks — Part XV: Target Retirement Funds, the simplest path to wealth of all – http://markjacobsen.net/l/1839

Fri 8/9
jlcollinsnh – Stocks — Part XVI: Index Funds are really just for lazy people, right? – http://markjacobsen.net/l/1840

Weekly Round-Up: 7/28/13 to 8/3/13

The Weekly Round-Up is a once weekly collection of my #1Aday daily shares. Hope you find something of interest!

Mon 7/29
jlcollinsnh – Stocks — Part VII: Can everyone really retire a millionaire? – http://mjg2.net/l/1831

Tue 7/30
jlcollinsnh – Stocks — Part VIII: The 401K, 403b, IRA & Roth Buckets – http://mjg2.net/l/1832

Wed 7/31
jlcollinsnh – Stocks — Part IX: Why I don’t like investment advisors – http://mjg2.net/l/1833

Thu 8/1
jlcollinsnh – Stocks — Part X: What if Vanguard gets Nuked? – http://mjg2.net/l/1834

Fri 8/2
jlcollinsnh – Stocks — Part XI: International Funds – http://mjg2.net/l/1835

Weekly Round-Up: 7/21/13 to 7/27/13

The Weekly Round-Up is a once weekly collection of my #1Aday daily shares. Hope you find something of interest!

Wed 7/24
jlcollinsnh – Stocks — Part IV: The Big Ugly Event, Deflation and a bit on Inflation – http://markjacobsen.net/l/1828

Thu 7/25
jlcollinsnh – Stocks — Part V: Keeping it simple, considerations and tools – http://markjacobsen.net/l/1829

Fri 7/26
jlcollinsnh – Stocks — Part VI: Portfolio ideas to build and keep your wealth – http://markjacobsen.net/l/1830

Weekly Round-Up: 7/14/13 to 7/20/13

The Weekly Round-Up is a once weekly collection of my #1Aday daily shares. Hope you find something of interest!

Mon 7/15
MMM @mrmoneymustache on: Getting Rich: from Zero to Hero in One Blog Post – http://mjg2.net/l/1823

Tue 7/16
Craig Jarrow @TMNinja says: Beware: 10 Time Management Rules That You Are Breaking – http://mjg2.net/l/1824

Wed 7/17
jlcollinsnh – Stocks — Part 1: There’s a major market crash coming!!!! and Dr. Lo can’t save you. – http://mjg2.net/l/1825

Thu 7/18
jlcollinsnh – Stocks — Part II: The Market Always Goes Up – http://mjg2.net/l/1826

Fri 7/19
jlcollinsnh – Stocks — Part III: Most people lose money in the market. – http://mjg2.net/l/1827

DB2 Incremental Delete

Ever have to delete a lot of records from a table in DB2 and can’t truncate, but you keep filling the transaction log? One way of solving the problem without having to manually update ranges of values in a where clause is to do an incremental delete in a stored proc. Here’s an example/template to get you started…


WHILE EXISTS (  SELECT  ITEM_ID 
		FROM    XX.TABLE
		WHERE   SOMETHING_NB = 1
		FETCH FIRST 1 ROWS ONLY )
DO
	DELETE FROM 
		(SELECT ROW_NUMBER() OVER() AS ROW_NB
		FROM    XX.TABLE
		WHERE   SOMETHING_NB = 1
		FETCH FIRST 20000 ROWS ONLY)
	WHERE ROW_NB <= 20000;
	
	IF ((L_SQLCODE_NB <> 0) AND (L_SQLCODE_NB <> 100)) THEN
		SIGNAL SQLSTATE '20003' SET MESSAGE_TEXT = 'Error deleting records';
	END IF; 
	
	COMMIT;
END WHILE;

Weekly Round-Up: 7/7/13 to 7/13/13

The Weekly Round-Up is a once weekly collection of my #1Aday daily shares. Hope you find something of interest!

Mon 7/8
Eric Jackson on: The Ten Biggest Lies of B-School – http://mjg2.net/l/1819

Tue 7/9
Scott Hanselman @shanselman asks: Programming’s not for you? How about thinking? Be empowered. – http://mjg2.net/l/1820

Wed 7/10
Adam Dachis @adachis on: How to Quickly Find and Replace Text Across Multiple Files with One Command – http://mjg2.net/l/1821

Fri 7/12
Leo Babauta @zen_habits tells you how to: Create the Habits of Being Lean, in 7 Years – http://mjg2.net/l/1822