No. Pre-execute cannot be skipped either. It is a part of the run-time. If the query is doing nothing more than a Clustered Index seek, and it...

There are plenty of things within SQL Server to entertain (err time sink) one's self as well. Find something within SQL server to learn or make better. Teach...

Jalapenos

That seems proportionate to a double run (validation and...

I was thinking the delayvalidation flag that can be set to true. During runtime, the runtime engine validates each task as it reaches it. During runtime, the delayvalidation...

bcsims 90437 (5/6/2010)

---

CirquedeSQLeil (5/6/2010)

---

Lynn Pettis (5/6/2010)

---

Actually, the problem is I'll need a vacation from the vacation. A week from Sunday will be 14+ hours of driving (coming home from...

When you are running this, are you running it as a job or directly from BIDS?

It looks like you can do an upgrade. You will need to perform a custom installation to do that.

http://blogs.msdn.com/sqlexpress/archive/2009/06/15/installing-sql-server-2008-guidance.aspx

eric_russell 13013 (5/6/2010)

---

The following query returns the name, execution count, min/max execution time, etc. for all stored procedures. It can also be extended to include CPU utilization and also performance...

If you are truly on sql server 2008, I recommend you look into altering the data type to varchar or nvarchar(max) instead of text. Text data type is going...

GilaMonster (5/6/2010)

---

Um.....

MVP status is not something that you should be 'going for' as a career goal....

Have you considered turning off pre-validation?

If the DBA is in the sysadmin role, then the DBA will have access to the data. The DBA would need to not be in the sysadmin role. ...

How well does the SP perform outside of the package? Have you checked indexes? What does the proc look like?

I agree. ...