Thomas LaRockThe original idea for this blog was to write about some of the craziest things you would ever want to do with MS SQL Server. Things like building DTS packages that have a single T-SQL task that executes a stored procedure, or building a database that has but a single table with 800 million rows … Read more
At some point in my life I was introduced to the idea that there are four corners of knowledge, or something to that effect. And the corners are labeled “Things You Know”, “Things You Don’t Know”, “Things You Know You Don’t Know”, and finally “Things You Don’t Know That You Don’t Know”. Gradually I have … Read more
The other day I found myself at the gas pump, topping off the tank of my economy car with $50, and wondering why there is not more outrage at the high cost of gasoline these days. Sure, people moan about it, but there is no real rage. And there are no long gas lines either, … Read more
Of course, nothing ever happens at work until you want to log off and head home. Such was the case yesterday. I was shutting down my laptop when I received a phone call from a colleague who needed help with a query. Seems as if the results of their select were returning decimals with a … Read more
I managed to drag myself to the start line in Holyoke this past Saturday for the 33rd running of the Saint Patrick’s Day Road Race. I know what you are thinking, you are thinking “hey, Saint Patrick’s day was two weeks ago”, and you would be right. Traditionally, the road race and parade are held … Read more
Here is something that happened in our shop last week. We had a developer sound a fire alarm because he found that his server was paging. He was kind enough to send along a screenshot from task manager: This server is running 2003 R2, x64 Enterprise, SP2, with 4 CPU (hyper-threaded). The task manager has … Read more
