June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Error: Fix: Msg 5133, Level 16, State 1, Line 2 Directory lookup for the file failed with the operating system error 2(The system cannot find the file specified.) – Part 2

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages
Errors are a great starting point for learning. Especially, my inbox is always flooded with atleast 2-3 error messages almost every other day. People keep asking me how to solve them, what to do when we encounter an error and so on. Long time back I wrote a simple blog…
Read More
All Articles document-error-flat

SQL SERVER – Error: Msg 701, Level 17, State 103. There is insufficient system memory in resource

Pinal Dave
SQL
In-Memory OLTP, SQL Error Messages, SQL Memory, SQL Scripts, SQL Server

Talking and exploring In-Memory topics in SQL Server 2014 has been interesting to me. When I wrote the blog around table variable not being just an In-Memory structure, one of my course listener (SQL Server 2014 Administration New Features) pinged me on twitter to ask, if In-Memory OLTP was really In-Memory? Wouldn’t SQL Server like to swap the data or memory data to pagination file when there is memory pressure? I told them the concept of In-Memory is that data always resides in memory and the reason for a feature name “In-Memory OLTP”. Let us see how we can fix errors related to insufficient system memory.

Read More

SQL SERVER – The DBA goes to MARS – Maintenance, Architecture, Research and Support – Notes from the Field #063

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field, SQL Server Security
[Note from Pinal]: This is a 63rdth episode of Notes from the Field series. Storytelling is an art very few have mastered in their life. When I requested Stuart to share his ideas about his famous blog about MARS, I really had not expected the response which I have received in…
Read More