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 Responses to 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.
[...] For the RunAS Radio blog post (and comment J), go here: RunAs Radio Interview Posted – "Kim Tripp Indexes Everything" [...]