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...

PiMané (9/21/2012)

---

So it depends mostly on the data in the tables.

Being a "generic" software spread across the country we can have databases with customers mainly from one state (where...

Yep, I agree set-based processing is the biggest.

After that, some talk about why modifying databases is such a pain. Why relational storage is actually good for performance, not just a...

You'll need to set up basic monitoring to understand more fully what's happening on the system. Gails articles are an excellent place to start. You can also look at the...

Well you know I loved this article. I've been ranting about this issue for quite some time. It's nice to have yet another resource to point to in order to...

SQLRNNR (9/21/2012)

---

SQL Kiwi (9/21/2012)

---

Brandie Tarvin (9/21/2012)

---

I can't blame him for being defensive. Eugene basically invited Celko into that thread for the sole purpose of roasting him. There really was no...

Lowell (9/21/2012)

---

ok, I have my own my knee jerk reactions for the things to review.

Grant wanted to avoid putting the answers on the forum, but i'd kind of like to...