JustMarie (1/22/2014)

---

Thanks Kraig. That's exactly the kind of thing I needed to know to help make the decision. I was looking at uniqueness and contention didn't come to...

No, it won't. Log backups do not shrink the file. Though, if it hasn't changed in size that means...

The query you...

Log backups don't shrink the log, they're not expected to shrink the log. They mark the space within the log file as reusable. What you describe is normal and expected.

That query does not get you the top 10 CPU-using queries.

It gets you a (fairly meaningless) set of the top 10 wait types. I say meaningless, because it hasn't...

Suspended just means it's waiting for something, probably a lock or IO. Be patient.

You shouldn't even be shrinking the log. If the log is growing, make the log backup more frequent or identify what is causing the log growth and resolve it.

btw, going...

Have you confirmed that the subquery, function on a constant and conversion in the select are the causes of the poor performance?

If you haven't, then making the changes you request...

thbaig1 (1/17/2014)

---

Hi,

I have several rule on my item name to compute its gender. I know this structure might need to tune , but currently can't change:(

I wrote sql and its...

Clustered indexes over multiple columns isn't usually a great idea. What are you trying to achieve?

What is the exact command you are using to backup the log (or if a maintenance plan, what are the exact options)?

That was fixed in SQL 7...

Selects do not take exclusive locks unless there's a locking hint and they do not hold locks until the end of the transaction unless there's a locking hint.

Sure it's...

In the default isolation level shared locks (from selects) are held no longer than the end of the statement. Exclusive locks (from data modifications) are held until the end of...

Insert ... Select can also be minimally logged.

Though how much it matters with temp tables which don't log redo information as it it (which is most of what's different between...