Ohio North SQL Server User Group

Choose a meeting below to view its details


Meeting Archive

Tuesday,

March

19

ONSSUG Akron Meeting March 2019

  • In-Person @ 526 S. Main St Akron, Ohio, United States (map)
  • 18:00 - 20:00 Eastern Daylight Time
  • Language: English

Erik Darling : What Else Can Indexes Do? (Remote Session)

Featured Presentation:

What Else Can Indexes Do?

Erik Darling, Managing Director Erik Darling Data

Lots of sessions about indexes give you technical, but not practical information. It's not that the information is bad, it's just that you can't take it and apply it to your problems. In this session, we're gonna dive deep into how queries use indexes, and the warning signs you'll see when you have a problem indexing can solve. We're going to be looking at query plan stuff like memory grants, spools, and lookups. We're also going to look at how indexes can give you a leg up on locking. And best of all, you'll learn how to stop worrying about fragmentation and start fixing real problems.

About Erik:
Erik Darling started using SQL Server after a dispute with Excel over a vlookup. Since then he's had some terribly boring DBA jobs, and been a consultant for Some Guy You've Never Heard Of™. He enjoys public arguments with the optimizer and wine photography.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids