Let us fix error TempDB error: CREATE FILE encountered operating system error 3 (The system cannot find the path specified.)
SQL SERVER – Is Query from Cache? Execution Plan Property
Well, of course, there is an easy way to know this and that is Execution plan property. Is there any way to know if the executed query is from cache or not?
SQL SERVER – SQLOS Scheduler and the Process States
I strongly suggest that you first watch it before we continue on today’s topic of SQLOS Scheduler and the Process States.