As far as memory leaks go, I'd look at anything other than SQL running on that server. Are there any other services (other than necessary Windows ones) running? ...

My worst office is easier to pick out than my best. The worst, by far, was when my "office" was a desk in the server room, because the company...

The way the trigger is written will definitely have performance implications. The question of whether or not to write a trigger is based on policy. How to write...

For a full list of what editions have which features, check:

http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx

Glad we could help. You're welcome.

No problem on the lack of expertise. We all have to start that way, I just beat you to it by a few years!

SSIS is "SQL Server Integration Services",...

littlebeeper110 (1/6/2009)

---

That's a good idea. I think the plan is to correct the db in the future, but for now to run a script to see if the table...

To clarify, the decision as to whether to include it in a trigger or not is based on coding needs, not on performance.

If the table will ever be updated through...

If you truly are limited only to dashboard reports, it sounds like you're on the right track as to how to use them.

On the other hand, why would you be...

Just had another thought. You could accomplish much the same thing as the complex join statement by using an Except query between inserted and deleted and then joining to...

Marios Philippopoulos (1/6/2009)

---

GSquared (1/6/2009)

---

On the point of making sure the inserted and deleted tables are different, a trigger can look like this:

update MyTable

set LastUpdate = getdate(), LastUpdateBy = user

from...

It's not a question of the type of join being used. It's a question of whether SQL Server thinks the indexes will help or not.

If, for example, you're joining...

Because if it's not in the outermost query, you can't guarantee it will work. Might, might...

I'm not totally clear on what you're asking, but it seems to me that you're updating a view and trying to figure out how to get that to update the...

GilaMonster (1/6/2009)

---

GSquared (1/6/2009)

---

If the UDFs are the ones that you define a table variable for the output (called "multi-value UDFs"), then that's probably the biggest source of the performance problem....