Archive for February, 2012
More Interview Questions
I wrote a post many months ago with some interview questions for my old boss to use when searching for my replacement. Tomorrow, we have a candidate interviewing to join our team. Here are a few things from the top of my head that I just might ask. You’ll need to find your own answers, [...]
Selectively Updating Statistics
Most blogs should have a disclaimer that your mileage may vary. That’s not the case here. I can assure you that your mileage will vary. Test this before you run it against your 12 TB production data warehouse. I recently inherited a few servers that have autoupdate of statistics disabled. That’s a long story. In [...]
The PNR Datatype
About sixty years ago, American Airlines, in conjunction with IBM, revolutionized an industry by introducing the first computer-based inventory management system called SABRE. This was revolutionary in many ways. Not only did it change the way the travel industry booked plane tickets and hotel rooms, but it also gave the public their first view of [...]
Random Blogs
A couple of weeks ago, I presented at the SNESSUG and had an excellent time. They’re a great group and were a lot of fun. One of my slides was to “Beware of Advice from Random Blogs.” I say this because there is just so much bad advice out there. Know your sources. Challenge the [...]