Nilas Jensen's Library tagged techhints →  View Popular

To identify the folder where Outlook 2002 and earlier store your data:



• Click with the right mouse button on Outlook Today either in the Outlook bar or in the folder list.
  
• Select Properties from the pop-up menu.
  
• Select Advanced....
  
• Notice the path listed under Path:.
  
• Select the path excluding the file name (usually this will be "outlook.pst") with your mouse.

Improving query plans with the SCHEMABINDING option on T-SQL UDFs

This blog describes how the SCHEMABINDING option specified during creation of T-SQL UDFs may affect query plans involving these UDFs in SQL Server 2005. Armed with this knowledge, you may find that you can dramatically improvement your query performance for free.

Before I jump into the details, let me briefly summarize the take-away: If you are using simple T-SQL UDFs that do not touch any tables (i.e. do not access data), make sure you specify the SCHEMABINDING option during creation of the UDFs. This will make the UDFs schema-bound and ensure that the query optimizer does not generate any unnecessary spool operators for query plans involving these UDFs.