Luis Cazares (4/30/2014)

---

pooyan_pdm (4/30/2014)

---

well, in some cases it could have some performance impact depending on the workload, disk subsystem,...assuming you've also set the log backup jobs on your databases, ...

Tons of stuff has changed. First, did you change the compatibility level on your database to 120? If not, you're using the old statistics with the new optimizer in compatibility...

Careful. It's at least partly a myth that denormalized storage is faster. It...

In some situations it will help performance to have a...

shafirmubarak (4/30/2014)

---

Thanks,

For example, user id is used as a linkage across multiple tables.

I am concerned about defining a key for the child tables as it requires 3- 9 columns...

Instead of trying to capture the plan live, just get it from the plan cache using sys.dm_exec_query_plan. You can combine it with sys.dm_exec_sql_text to identify the specific code you're interested...

Until all performance stops because...

If the other indexes were created for a reason and the code hasn't been modified, then the likely answer is that they're still needed. You can look at the usage...

This is the third thread for the same problem.

Have you done any of the things I've suggested on the other two?

There is a tiny impact on performance because you're using resources to backup the logs. But it's really tiny. If you're already at 99% resource usage, adding this might be...

Since you've posted this question to a second location, we're now getting into cross-chatter. I made several recommendations over there for how to fix it. It depends on your data,...

Ha! In short, no, it doesn't "stay shrunk". As you add data (or junk mail) to the system, it's going to need to grow to contain that additional data. You...

I would love to...

OK. Please follow my advice about investigating the execution plans.

Modifying the query will cause a recompile. But you also get recompiles from other sources. You can get a recompile because...

I strongly recommend looking over the execution plan for the query and do your own investigation and tuning. The DTA is notorious for making poor choices at times and you...