The cached execution plan will be reused, providing nothing else has happened to throw it out of cache¹. This may or may not be a good thing.

http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/

1) Schema change, stats...

If the index was corrupt then, depending on the type and severity of corruption, a drop/recreate of the index could well have fixed it or simply deallocated the corrupt page....

One thing you could do, what was done with the last Itanium server I worked with, is to set up a second server, an x86 or x64 machine with a...

sqlguy-549681 (4/25/2010)

---

I know that There is no 32-bit design-time or run-time support for DTS packages on Itanium-based operating systems. Therefore, I cannot create, view, modify, or run DTS packages...

x64 or IA64 (Itanium)?

If Itanium, there are some things to consider re drivers and utilities. x64 code won't run on an Itanium, so you have to get Itanium versions of...

Define 'last'

If you mean 'most recently entered', then you need some column that shows the order entered. Date inserted or an identity column. Order by that desc and use TOP

If...

Other stuff running on the server, network delays, etc. You haven't given any numbers, but if the differences are small, then they can be ignored. Generally one would run queries...

Which one ran faster? Which one used hte least CPU? Which did the least IOs? Use either SQL profiler or STATISTICS IO and...

Why don't you run them and see which is fastest? If you find one is faster/slower and you don't know why, post the execution plan and someone's sure to have...

Please read through this - Managing Transaction Logs[/url]

The time it's taking has nothing to do with the schema lock. As I mentioned, all queries (select, insert, update, delete) take schema stability locks.

What's the query? How big's the...

You're trying to add a row with a primary key value that already exists. What's the primary key for that table?

This isn't a result of a restore, unless you restored...

Yes, but that's in a very...

No, inadequate licensing will not cause performance problems, it'll just get you hit with a fine when Microsoft does a software audit.