title: Should you use master.dbo when accessing sp_ procedures?
body: <p>I'm 100% convinced this is a duplicate but after more than an hour of searching I just can't seem to find the answer.</p>
  
  <p>When using special procedures (i.e. the <code>sp_</code> ones like <code>sp_executesql</code>), is it wise to use the full 3-part identifier <code>master.dbo</code> (or <code>master..</code>) or just use them as is?  I'm looking for the most performance optimized version of this:</p>
  
  <pre><code>1. sp_executesql
  2. master..sp_executesql
  3. master.dbo.sp_executesql
  </code></pre>
  
  <p>Are 2 and 3 identical in terms of performance specifically regarding the above (i.e. referencing <code>master</code>) and is it safe to user <code>master..</code> or should you not risk it even on <code>master</code> since someone could still create another schema there at some point?</p>
  
  <p>Much appreciated.</p>