Steve Jones - Editor (4/11/2008)

---

A higher salary might be more of something. It could be more responsibility (junior reports, mentoring, more servers, more data), it could more pressure (24x7, 5...

Actually - it has for some time, since it...

What version are you on (meaning - patch level)? CLR was more or less a large memory leak on anything prior to SP2.

Also - you seem to be using...

GSquared (4/11/2008)

---

Matt Miller (4/11/2008)

---

rbarryyoung (4/11/2008)

---

Michael Earl (4/7/2008)

---

This is a batch separator. In some places, it will impact what your scripts will do.

The semi-colon you have included is also a...

I'd think #2 might be faster, if the SP does the insert directly (no SSIS needed). The assumption would be that the flat file would be perfectly aligned with...

rbarryyoung (4/11/2008)

---

Michael Earl (4/7/2008)

---

This is a batch separator. In some places, it will impact what your scripts will do.

The semi-colon you have included is also a batch separator but...

Nobody Real (4/7/2008)

---

Thanks. I am aware of how to write the trigger, that's not my problem. As I said, I cannot change the existing trigger, so i'm looking...

Interestingly enough - 2005 gives you more options for doing grouped sums. You don't actually need to use the GROUP BY clause - you can use a SUM() OVER...

WRACK (4/10/2008)

---

Thanks Matt.

No I don't have any CLR functions and yes they all are scalar functions. None of them are database dependent.

e.g. I have a function called LCD which calculates...

ROLLBACK is one of the possible "mates" to BEGIN TRANS. The other is COMMIT.

Given what you're talking about, it would simply be something like this:

BEGIN TRAN

Update my table

set etc....

simply...

...

select field1,

case when [EmailAddress] is not null then 'QV' else 'PARK' end as Profile,

field2

from

... ...

what kind of error do you get when you schedule that copy database script? I immediately assumed "security problem" (meaning, the user running the scheduled job doesn't have the...

Michael Earl (4/10/2008)

---

I'm sure I'll get yelled at by someone for this post...

Don't be too bound on the "Stored Procedures are the only way" approach.

They are not necessarily the fastest...

You need to run the actual sub-query that you're using - it's not going to return the same as your query1. If you look - you will see that...

upendramkumar (4/10/2008)

---

Matt,

Thanks for the heads up on the 'where' clause.

So when I delete the totalprom != 0.0, I get almost 2898 rows which once again looks like a cross...