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

Like this? Consider joining my mailing list, or at least using my affiliate link when buying from Amazon πŸ™‚

You or someone you know looking to buy or sell?

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

Like this? Consider joining my mailing list, or at least using my affiliate link when buying from Amazon πŸ™‚

You or someone you know looking to buy or sell?

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

Like this? Consider joining my mailing list, or at least using my affiliate link when buying from Amazon πŸ™‚

You or someone you know looking to buy or sell?

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

Like this? Consider joining my mailing list, or at least using my affiliate link when buying from Amazon πŸ™‚

You or someone you know looking to buy or sell?

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

Like this? Consider joining my mailing list, or at least using my affiliate link when buying from Amazon πŸ™‚

You or someone you know looking to buy or sell?

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

Like this? Consider joining my mailing list, or at least using my affiliate link when buying from Amazon πŸ™‚

You or someone you know looking to buy or sell?

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;
Like this? Consider joining my mailing list, or at least using my affiliate link when buying from Amazon πŸ™‚

You or someone you know looking to buy or sell?

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

Like this? Consider joining my mailing list, or at least using my affiliate link when buying from Amazon πŸ™‚

You or someone you know looking to buy or sell?

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

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

Mon 7/1
Joshua Becker @joshua_becker on: 10 Unconventional Habits to Live Distraction-Less – http://mjg2.net/l/1815

Tue 7/2
MMM @mrmoneymustache on: Getting Enough.. and Then Some – http://mjg2.net/l/1816

Wed 7/3
Shelly Phillips on: Six Communication Tricks That Will Get Your Kids to Cooperate – http://mjg2.net/l/1817

Fri 7/5
Melanie Pinola asks: How Can I Keep My Family from Disturbing Me When I Work at Home? – http://mjg2.net/l/1818

Like this? Consider joining my mailing list, or at least using my affiliate link when buying from Amazon πŸ™‚

You or someone you know looking to buy or sell?

Happy birthday America

As I sit here watching “The Patriot” I can’t help but be appreciative of all those who have sacrificed for the dream and reality that is America. Those who gave the ultimate sacrifice and those who left their families – if even for a short time – in service of a cause they considered greater than themselves.

In salute of all the Patriots: Abe Lincoln, Alexander Hamilton, George Washington, John Adams, Sam Adams, Ben Franklin, Teddy Roosevelt, George Patton, General Sherman, General Grant, FDR, those who will never be known (the unknown soldiers), and many many more I am ever grateful to have been born in this wonderful Land of Opportunity.

As a parent, I haven’t the luxury of principles. I have long feared that my sins will come back to haunt me – and the weight is more than I can bare.

Thank you again to all who have sacrificed so that we may pursue happiness.

Like this? Consider joining my mailing list, or at least using my affiliate link when buying from Amazon πŸ™‚

You or someone you know looking to buy or sell?