I'd say that it's the XML that's killing you. Passing XML into a query is fine, but you should load it into temp tables as soon as possible. Constantly querying...

I don't know that I'd say that's always right, but yeah, that can be a great solution. Add the columns the the INCLUDE list of the index that was part...

EjSQLme (8/22/2011)

---

So, is it normal for a t-log to be over 10GB even though you are doing a t-log backup? If so, is there a way to manage the...

Christi Wilson (8/22/2011)

---

Okay, I have been getting my ducks in a row to get this started. Only thing I need is a domain name and I cannot think of one....

EjSQLme (8/22/2011)

---

Grant Fritchey (8/18/2011)

---

EjSQLme (8/18/2011)

---

Grant Fritchey (8/17/2011)

---

The size of the transaction log is usually reflective of the size of the transactions. Have you tried monitoring the freespace in the tran...

Then I don't think columnb needs to be in the index at all. Since it's a clustered index, columnb is stored at the leaf....

Indexed views are really only good if you have reasonably unvolatile data. If your data is being updated constantly then the indexed view is going to hurt more than it...

Roy Ernest (8/22/2011)

---

Yes, the existence of the stats for that column interferes with the selection of the index by the optimizer. I was banging my head with this issue one...

And does...

Assuming the plan is absolutely identical, then it sounds like resource contention or blocking. No way to know anything though based on the information supplied. These are just guesses.

It really depends on the queries. Are they getting seeks on the index or not? Also, you said primary key, but is it the clustered index? How the cluster is...

Roy Ernest (8/22/2011)

---

There is one problem with Autocreated statistics. It is rare but can happen and has happened in our environment.

Let us say we have a table with 6 columns...

I have heard of...

Statistics are very small. By & large they won't get in the way and usually help. Unless you're seeing an issue, I wouldn't mess with it.

That said, sure, you can...

Yeah, I'd need to see the execution plan.

The fact that there is no WHERE clause is concerning. Queries that don't filter the data frequently lead to scans and there's little...