Well… I think I had had too much tea that morning ;-). But, as always, chatting with Richard and Greg was great. Here’s the specific show link: http://www.runasradio.com/default.aspx?showNum=76.
Oh, and just for the record, I didn’t come up with that title. But, I do hope that all your [high-priority and important] queries are indexed!
Enjoy!
kt
2 thoughts on “RunAs Radio Interview Posted – “Kim Tripp Indexes Everything””
I have to say that I’m not a database guy. Not even a little tiny bit. But I found the show very interesting so I opened up the enterprise manager and started pokin around. (Just lookin, no touchin) Using the Query Analyzer I discovered that our main database doesn’t have a single index. Apparently the devs decided that they wanted the option of putting the tables on any kind of database server so they did not include a single index or key. I was told "all that is done in ‘The System’." Good grief.