Every time you execute a query against SQL Server, it goes through optimization and compilation and a query plan is generated. Most of the time that plan goes into cache (there’s always exceptions, which is a discussion for a separate time), which means that the next time that query executes, SQL Server can use the […]
Erin Stellato
The SQL Sequel
SQLskills 101: The Other Bad Thing About Clearing Procedure Cache
Posted on: July 27, 2017 9:44 am
Migrating to In-Memory OLTP…what’s stopping you?
Posted on: July 3, 2017 11:45 am
In the past few months I’ve had several clients reach out about migrating to In-Memory OLTP solutions. When the second or third request rolled in I remember thinking, “Finally!” As in, I’ve been wondering why businesses haven’t been looking to implement In-Memory sooner. In fact, I added a section on In-Memory to our IEPTO2 course […]
