This past Monday, I presented at TechEd North America for the first time. The session presented was Indexing Fundamentals for Microsoft SQL Server. Indexing is such a huge topic, that it was hard to boil down the fundamentals to a 75-minute presentation, but based on responses I think the resulting session was pretty good.
If you want to watch the session, I’ve got it embedded below. The demos from the session can be found here ([download id=”74″]).
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2013/DBI-B302/player?w=960&h=540
If you check out the demos and watch the session, you’ll notice that there are some demos that I didn’t have a chance to go through. Keep an eye on this blog because I’ll be posting some videos of those demos in the next few weeks. If you have any questions, please feel free to leave a comment. Also, you might be able to find the answer on my Index Resource page.
Strate SQL 
I was actually there and was the first one to ask you after the session about the untrusted foreign keys we found by accident on our DB. One quick question on the Foreign Key Pattern, sorry if this is too basic but:
If you avoid this: CREATE INDEX IX_Detail_ICP_HeaderID ON dbo.IndexStrategiesDetail_ICP (HeaderID)
You will not have the clustered index seek operation in the execution plan, Why would you need this index ?
LikeLike