As stated earlier... the most likely problem is the data cache. Unless having a 2000 lines proc with only 1-2 queries inside, the plan generation time will be futile...

Craig Farrell (1/21/2011)

---

Brandie Tarvin (1/21/2011)

---

Hey, Craig, even us non-employer types are learning a lot from this discourse. I've learned a lot about job descriptions just by reading your responses (and...

SSMS

open your server with windows account

security

logins

double-click on sa

general

type in the new password, confirm and hit ok

Login with windows admin account and simply change the password of sa.

My apologies, I didn't mean to be a jerk. I intented to give a strong vote to not do something so huge with cursors, which are much slower most...

CELKO (1/21/2011)

---

You better off doing the running totals in the front end in T-SQL. Do you have a report writer of some kind?

In Standard SQL there is an optional...

opc.three (1/21/2011)

---

For that large of a dataset a loop structure will likely yield the best performance. If you have an application layer I would recommend doing this type of work...

Wow, this discussion is almost as long as the article :hehe:.

Great job Jeff :w00t:.

Then you'll have to do with Jeff's article...

BTW you can't have a go statement in the definition of the trigger... the code will stop there.

DELETE SC FROM SecondaryCategory SC INNER JOIN DELETED D ON SC.[ArtistID] = D.[ArtistID] AND SC.[ArtistGenreID] = D.[ArtistGenreID]

Ferguson (1/21/2011)

---

GSquared (1/21/2011)

---

Just to beat this dead horse a bit more:

I have heard two threads in this -- one is "but when will I have time to do both" and...

So what's the question?

Maybe this can give you "our" perspective on money.

"Money isn't everything, but it ranks right up there with Oxygen",

Zig Ziglar.

From my perspective when I read a consulting offer, I...

Potato, Potâto :hehe:.