Is this a bulk insert operation, or just inserts as transactions occur?

If it's just "inserts" as a transaction occurs in the application you may want to follow logic such as.

1....

First, there isn't a difference between the versions of SQL2000 or SQL2005 when it comes to PK's, or Unique index. The difference is how the objects were created in...

...so the wise thing to do is NOT sign the NDA if you live in one of these countries/states then you're secure in employment forever! 😉

just kidding

Gianluca Sartori (6/16/2010)

---

Steve-3_5_7_9 (6/16/2010)

---

GilaMonster (6/16/2010)

---

Steve-3_5_7_9 (6/16/2010)

---

Actually, this makes a lot of sense. Sometimes it is difficult to terminate someone, especially if they have great performance reviews, so having a...

GilaMonster (6/16/2010)

---

Steve-3_5_7_9 (6/16/2010)

---

Actually, this makes a lot of sense. Sometimes it is difficult to terminate someone, especially if they have great performance reviews, so having a NDA on record...

bteraberry (6/15/2010)

---

Very few non-competes hold up in court. Their usage has more to do with the psychological impact than the reality of their enforceability.

But yeah ... anything in a...

Thanks, Grant. I'll scrutinize their wording to make sure no "funny business" is going on.

In the end, I suppose it isn't a big deal.

Thanks for the comment.

Ok, I see the point about company secrets, but this has to do with the data in a specific system.

Additionally it's illegal for me to sell the...

As mentioned above, you need to know the "why?" and be offered alternative recommendations by the auditor.

The SQL Agent is highly used and any vulnerabilities would be fixed by MS,...

We haven't had any issues since moving off of the SAN and to direct attached storage. It has been 3 months since moving to this new configuration.

Steve

Phase in the changes that you want to implement. This way you should meet less resistance and the developers aren't looking at you like the hatchet man! You...

...and something else to check with the SAN admin. Other applications might be sharing your disks (luns) as the drives are just virtual anyway. Another application may be...

It is a MS best practice to use static ports and also for security regardless of whether sql server is running on a cluster.

http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SQL2005SecBestPract.doc

1. It's better to open...

You're welcome.

What Windows Server OS?

It's probably because of the "Microsoft Support". MS tends to give answers based on what they support, or if they'll support it. This link talks...