Not many people know too many indexes are not bad for Insert, Update and Delete but also for Select statements as well. We will dive deeper on this subject and will show the secrets behind the scene stories with example. We will also display how they can solve this performance problem which they were not aware of it EVER. Slow Running Queries are the most common problem that developers face while working with SQL Server. While it is easy to blame the SQL Server for unsatisfactory performance, however the issue often persists with the way queries have been written, and how Indexes has been set up. The session will focus on the ways of identifying problems that slow down SQL Server, and Indexing tricks to fix them. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.
(no tags)
The video is not available to view online.