I'm still very uncomfortable with the loop approach. It's just going to be slow. But, you need to make sure that each command is a single transaction, or, the entire...

To my knowledge, no, no additional licensing needed.

However, always, always, the best answers for licensing is not some dude on the internet. You should go to Microsoft for confirmation.

If you know for sure that you've removed data permanently from the database and the data is not going to just grow to refill the space you freed up, you...

In your situation, I think you're right to focus on getting your queries to run as efficiently as possible. You won't be able to dictate hardware, so your maximum efficiency...

Yeah, I wish I wasn't already traveling so much...

If you're parachuting into a situation where there is no monitoring in place, then, as was already mentioned, use the Dynamic Management Objects (DMO) to query the cache in order...

There are scads and scads of processes that take place when you insert data. I'd suggest getting a copy of Kalen Delaney's book SQL Server Internals. That covers the process...

Looping within the SQL Server environment is generally a poor approach. If you need to validate data sets or behavior, I would strongly recommend finding a set-based approach to get...

You've got nested functions and you're accessing large amounts of data? That's a major design flaw. The only way to improve performance is back out of the use of multi-statement...

It sounds like you might be experiencing bad parameter sniffing... possibly. Recreating the view forces a recompile of the plan. If your statistics are aging over the week, but not...

It's hard to make real substantive suggestions based on general information. Bigger, faster hardware always helps some. Depending on how much you upgrade the hardware, you can mask really bad...

If very large data sets are needed, there's seldom much tuning that can be done through T-SQL or indexes. Usually, if you have to move extremely large data sets, you...

Ah, I meant databases generated by ORM...

CELKO (9/21/2012)

---

If you ask a VERY general question you will get a VERY general answer. The best general answer is not to use hints at all and trust the optimizer....

Roland Alexander STL (9/21/2012)

---

Which is the point of using local variables, since it will force a new plan each time the query is run. Of course, this is also the...