improve parse/compile time / sql server 2008

In SQL Server 2008, how does one improve parse/compile time?
Who is Participating?
Scott PletcherConnect With a Mentor Senior DBACommented:
Table hint:
NOEXPAND --will speed up only indexed views

Query hint:

Note that these options may not result in the best plan, but should result in a plan being generated more quickly, i.e., improved parse/compile time.

More generally, always specify schema names on all objects -- this can drastically reduce the need for SQL to check for possible different schema names, and can allow better sharing of plans, reducing parse/compile time because more users could automatically use the same plan.
Brian CroweDatabase AdministratorCommented:
You're going to have to be more specific
PortletPaulConnect With a Mentor Commented:
ditto, but in the meantime:

by avoiding it
perhaps this will give you some ideas:
Anthony PerkinsCommented:
In SQL Server 2008, how does one improve parse/compile time?
Easy, you execute them on a faster server...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.