SQL to remember

SELECT * FROM syscomments s

LEFT OUTER JOIN sysobjects o ON s.id = o.id

WHERE text like '%Search Term%'

That is how you search through (in my case) stored procedures in a database. Works in SQL 2000. No that's not a typo.

SQL 2008 Writeback

When attempting to do a writeback in Excel 2010 the following error is returned:

"Data could not be retrieved from the external data source.
Error message returned by the external data source:

Server: The operation has been cancelled due to memory pressure."


I repeated the same action while looking at the resource monitor on the server that the cube was located. The memory linearly increased from 17% to 99% then started hitting huge seg. faults with varying memory consumption until the error was displayed in Excel.

So it's a memory problem.

And the interesting thing about this, SQL 2008 analysis services doesn't flush the memory until someone connects to it. (i.e. the memory on the server didn't drop back to 17% until I did a reconnect in SQL Server Management studio to the cube)

Apparently this cube needs to be designed better or the server needs more than 4GB of RAM.



Not that you wanted to know this...whoever decided to read it.

From a Zoo to the Sea

This conversation pretty much sums up the list of things I did on my drive out west.

Me: started in kzoo
: first stop in gary
: then outside of chicago for giordanos pizza
: then drove through the bad lands in south dakota
: mount rushmore
: drove through a bit of wyoming
: past lake flathead which was pretty neat
: to glacier
: did some driving and hiking in glacier national park
: (northern montana)
: saw a drunk driver ejected from their car while driving the back roads of montana
: drove to seattle
Friend: wow
Me: saw the space needle, pikes fish market
: downtown seattle
: then a seattle sounders game
: (soccer)
: went on a picnic
: in bellingham
: played some darts
: took a train from bellingham to seattle
: saw an aircraft carrier, which was awesome
Friend: sweetness
Me: went bowling
: horse back riding
: went go carting, with go carts that actually went fast
: you actually had to use the brake
: halo lan party
: went to a wedding
: flew back
: played some ultimate friz. then drove to auburn hills for work the next day
: i think that's about all
: after the key west trip that is
Friend: awesome
Me: oh and I forgot to mention wall drug

Graduated

Finally Graduated.
Finally wrote something on this blog.
Finally realized my inability to utilize amazing opportunities that God sends my way.

In the past month, I have been from Key West to Seattle and seemingly everywhere in-between. The Lord has undoubtedly granted me safe travels. So I thank those of you who have been praying for me. Traveling the myriad of miles has afforded me abundant time to ponder and enjoy God's creation.

It hasn't been until recently that I have begun to grasp the thorn of the rose due to travelling. I enjoy seeing new places. I enjoy meeting new people. I do not understand people do not enjoy travel. Travelling in this regard is the essence of leaving home. As the idiom goes, home is where the heart is. And the heart, the heart is where the people you long to see.


One last thing for now: don't drink and drive.
'til I write again...godspeed

Socially Optimal

Socially optimal doesn't occur normally. Totally had one of these moments today:

another classic from xkcd.

The Last Stand

My final semester of undergrad is drawing near an end. One thing I learned was that it is a joy to serve the Lord, creator of this universe.

So here I stand, humbled by His glory.

Needed a post

It's been a long time coming, and I'm straight with that. Even with the semester being the easiest semester in my life, I still feel like a lack time. I am looking forward to finishing classes and even more for my planned travels in May.

The Fundamental Engineering Exam seems to be coming fast along with the due date for the senior design project. All each will take is for me to take some time and focus on each. That goes along with a project at work which I would have liked (as well as the client) to have been deployed along time ago.

Other than those items, things seem to always be changing. (and some person got me watching Lost, grrr). I'm just not sure where to start. So...

Key West, Montana, and Seattle here I come.