Where you off to?

Tony watching the place while you're gone?

Couple problems straight off.

That trigger will only work right if there's one row updated. If there's more than one row updated, only one of them is going to be 'processed'

You're...

shnex (6/26/2009)

---

I have a index seek only for id and fk3(the first column in the enumeration for non cl index). The result was the same for other examples too, the...

Also...

Identical. In fact, if you look at the exec plan, you'll see that the plans are the same and that SQL has converted the IN into a series of =...

Paul White (6/26/2009)

---

#temp3 is a local temporary table - it is private to the session that created it.

Dynamic SQL runs in a separate context, so it cannot see the private...

Can you post the full code including where the temp table is created please?

Are you sure that the column 'Car_ID' exists in that table because the error indicates that it...

mazzz (6/26/2009)

---

I've been vaguely planning to set up a db in which to store historical DMV data, might make a starty on that this afternoon, as there's a bit of...

Start SQL Agent?

Shouldn't be necessary. That's generally...

I'd start by trying to optimise the ETL process. It's possible that there's no more that can be done, but it's unlikely.

If that gives no joy, then spreading the work...

yaya1899 (6/26/2009)

---

Hi GilaMonster,

Basically I have few tables to store system data of application, and those data maybe added/updated from time to time. Thus, I have a master script to store...

When I started playing with these...

mazzz (6/26/2009)

---

The "duplicate" rows returned from the DMV have the same qs.text, the same plan_handle, the same sql_handle, but different statement_start_offset and statement_end_offset. Some of these rows have the same...

yaya1899 (6/26/2009)

---

Recently I learned about CURSOR and I found most experts advise not to use it due to performance issue. However, I found using CURSOR is much faster than using...