Grant Fritchey (3/14/2008)

---

I don't know if I'd call poking holes in water the "front lines" but from what I saw of the AF, you guys had it pretty sweet.

And Jeff,...

You guys out on the front lines while I served 4 years in the Country Club (aka Air Force). All the best to you!

😎

I think I saw the light. Is this what you are trying to get?

SELECT

crmaf_account.name AS Company,

crmaf_account.new_membershiptypename AS MemberType,

...

Okay, I reformatted the code, but I still don't really know what you are looking for. part of it is I am not sure which table is which that...

GilaMonster (3/13/2008)

---

Bracket in the wrong place. This passes a syntax check.

CREATE TRIGGER trg_PreventInvalidHours ON Works_On AFTER UPDATE AS

IF EXISTS (SELECT 1 FROM inserted i inner join deleted d

on i.ESSN...

Asking for more:

For a better response, please read the following article. It provides excellent guidance on asking for help.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

There are plenty of people out here who would like to...

Grant, you and my brother would defintiely have some stories to tell. He was nuke in the Navy also. He served on CVN-65.

I wish I could remember the...

Set MAXDOP to 1 on the server, and reran the query and .........

the winner is .........

it took 30 seconds versus to 27 seconds for the straight select!!!!

This now goes back...

UNC paths are they way to go in SSIS. The only place I have had a problem with not being able to use a UNC so far is with...

I think I have come up an explanation. Part of it comes down to parallelism. The straight select has a parallelism of 1, the select distinct has a...

For a better response, please read the following article. It provides excellent guidance on asking for help.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

There are plenty of people out here who would like to help, but...

And I will second Jeff's assertion.

😎

For the DR site, I'd go with log shipping. If you use HA mirriorring (automatic fail over), and you have a node failure in your cluster, the mirrior will...

The problem here is that we haven't seen the entire execution plan, only what we have been told. Again, the cost is relative to the batch its self, and...

Read BOL (Books Online), it will provide you all the info you are asking.

😎