leonp (5/8/2008)

---

I am inclined to believe so too .. Is there any reason why the sql server will be responsible for this slowdown? I want to make sure we (SQL...

bcronce (5/7/2008)

---

Here's a question. Would overall performance be better when joining on a dept id vs name because of the comparing of int vs string? I would assuming other tables...

Well it is reading the transaction log sequentially and it cannot tell ahead of time which transactions will ultimately be committed and which will not be.

So instead it just "Rolls...

What kind of SAN is it? Are there other servers using it also?

If so, then your slowdown could be caused by contention with those other servers for the same...

The best "quick" solution would be for you to take the identity property off of the audit table.

post the SQL code for the proc and the views. also attach the xml for the good & bad query plans.

Let us know how it works out.

Glad I could help.

Well, you can always use an OR:

SELECT ITEMNAME

FROM ITEMS

WHERE ITEMNAME LIKE '%Good%'

Or ITEMNAME LIKE '%Bike%'

To do this with a parameter, you would have to split...

Actually, I've discovered recently that that does not in fact script everything in the database. For instance there are no Service Broker objects on the list.

Kind of disturbing, if...

It worked before because you didn't have any records with CustomerCode='XX'. Now you do.

Well, the Cursors are probably killing any ability to parallelize so your 2x4 core desktop is probably using the same number of cores as you dual-core laptop: 1.

And cursors tend...

Well, there's a lot of differences between triggers in Oracle and SQL Server, such as:

1) SqlServer triggers as always per-statement and never per-row. So if one UPDATE statement modifies...

It's more than just the math, Gus. The source and output column names actually indicate that it is going from Hectares to Square Meters.

Really?!? Could you site a reference for this? The only general "Best...