Month: October 2008

more SQL silliness

Well, after thinking I had my SQL problem licked, it came back. I finally got a callback from a support guy at Microsoft, and he had me update statistics on all the tables involved. That fixed things, and everything has been working now for the last couple of days. I’m pretty sure I’d updated statistics on all these tables at least once since the original problem occurred, but maybe I didn’t, or maybe I just needed to do it two or three times to get everything back to normal.

I’ve always had a maintenance plan that updates statistics on all my tables once a week, and I don’t think I’ve ever had problems with statistics before.

I’ve been reading up on this whole statistics thing now, which I admit I hadn’t paid much attention to, until this little debacle. Here’s a blog entry by Kim Tripp that explains a few things about the auto-update mechanism, and another one by someone at Microsoft that explains a good bit about the way statistics work in SQL 2005.

SQL patching fun

After all the patching I did over the weekend, it seemed like everything was fine on my main SQL server. However, on Monday, we discovered that a couple of oddball SELECT statements weren’t working anymore, returning the error “Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.”

To make a very long story short, I eventually figured out that I could get these queries working again by deleting all of last year’s data from one of our bigger tables. The table in question had about 32 million rows in it. I cut it down to 13 million after getting rid of the 2007 data. The moral of this story, apparently, is that you shouldn’t try to store 30 million rows in a single SQL Server table. I say this with tongue in cheek, since, obviously, there are other people out there with very large tables in SQL Server. Apparently, I can’t be one of them, though.

I put a call in the Microsoft support this morning, but they never called me back. Maybe tomorrow. If they do call back, and I get a support guy who seems to be a bit less clueless than usual, maybe I’ll try to see if we can figure out why my server chokes on this table. If I get the usual clueless support dude, I guess I’ll just tell him I figured it out on my own while I was waiting for a callback. I wonder if I get my support incident credited back if I solve my own problem while I’m waiting for the callback?

random patching

I spent a bunch of time on Friday night bringing my various home machines up-to-date with patches and software updates. The impetus for that was largely this security hole in Windows, which seems to be the biggest vulnerability that’s cropped up with Windows in quite a while.

I was also interested in updating my VMWare Fusion install to 2.0. Ars Technica has a good review of Fusion 2 up on their site. I did the upgrade, and it was pretty smooth, but I haven’t had time to play around with it enough to tell if it will work any better on my old MacBook than the previous version.

I realized that I hadn’t turned my Dell Vista laptop on in about a month, so there were plenty of patches and updates to run on that. And I hadn’t started the virtual machine I have set up under Fusion in a while either, so there were a bunch of patches to install on that too.

On Saturday, I remotely applied a whole bunch of patches to our servers at work. The main goal was to get that Windows patch on all the servers, but I also had a bunch of other patching to do. I’m embarrassed to say that I’d never updated our main SQL 2005 server to SP2. That had been on my to-do list for about a year. And I had to apply a cumulative post-SP2 patch file to our HR/payroll SQL server, since our HR/payroll software vendor requires that I bring the server up to that level before I can apply their year-end update. It took about three hours to get all that done. Happily, nothing locked up at any point, so I didn’t have to drive into the office just to power cycle a server. (And, yes, I know there are devices that would allow me to power cycle a machine remotely. But we can’t buy any new equipment right now.)

I have one Windows 2000 server that’s hanging up on one of the updates. I’ll probably have to bring that one up to date in safe mode or something. I really don’t know what’s wrong with it, and I’d like to just get everything off it and moved to a WIndows 2003 machine, but I don’t have the time right now.

I got some interesting errors on the two machines to which I applied SQL updates. There’s a long thread on this problem here, at the Microsoft forum site. I haven’t figured out if this error is actually going to be a problem or not. There’s certainly a lot of confusing (and sometimes conflicting) advice out there on it.

I’ve been watching the Jets game today, and enjoying the newest Mac vs PC ads that Apple’s been airing. The theme is basically how Microsoft is spending a bunch of money on advertising instead of fixing Vista. I have to say that I agree with that. This new security hole apparently exists in every version of Windows from Win 2000 to Vista and Win 2008 Server. There’s an interesting blog entry about MS08-067 and the SDL, covering the failure of the SDL (Security Development Lifecycle) to catch this bug. To quote from the article: “I’ll be blunt; our fuzz tests did not catch this and they should have.” I can’t help but think that a little bit of that Seinfeld cash might have caught this one earlier. I’m probably over-simplifying. These things are really complex, and a lot of stuff can go wrong that no pile of cash can fix.

Meanwhile, I’m looking forward to the Giants game this afternoon. It should be a good one. Well, this was a really long (and probably boring) blog entry, but I haven’t written anything in a few weeks, so I was due for a long one. I’ve got a bunch more random thoughts in my head, but I’m going to resist the temptation to make this entry any longer!

Kindle 2

It looks like someone has leaked some photos of the Kindle 2. I’m perfectly happy with my original Kindle, and, just from the photos, I don’t think I’d necessarily want to trade it in for the new one. I have to admit I don’t do much with the Kindle, aside from reading Newsweek and the NY Times. I’ve read one novel on it, and a handful of short stories. Since I joined Bookmooch, I’ve wound up with a fairly large backlog of “dead tree” books to read. I think I have about 20 novels stacked up right now.