Jeff Moden (9/14/2010)

---

Derrick Smith (9/14/2010)

---

It's the combination of that and creating it in a transaction thats causing the issue here. SQL needs to keep the lock on those tables in...

No you can't - DML triggers are at the table level, which is why...

It's the combination of that and creating it in a transaction thats causing the issue here. SQL needs to keep the lock on those tables in case you decide to...

ken.yannitell (9/14/2010)

---

Use this statement at the top of your query:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

This will make any table look up perform the same as the Hint (With...

How are you automating the creation of a trigger?

Couldn't you just use the same method to automate the deny of insert/update/delete?

What is your parallelism set to? Have you tried setting MAXDOP 1, 2, 4, 8, 0 to test if results are any different? How about memory usage? Did you cap...

How about you just deny insert/update/delete (or don't grant to begin with) permission on those tables to those users? Triggers should be a last resort.

DHeath (9/14/2010)

---

In my eyes the biggest benefits of 64 over 32 is memory usage and taking full advantage of the newer hardware(true hyper-threading) that continues to come available you know...

That's less than 1% difference, so no, that won't really affect it.

It sounds more like Table 2 is missing indexes or statistics. Take a look at the execution plans for...

Yes

Try this: http://support.microsoft.com/kb/955404

JC-3113 (9/14/2010)

---

H iJeffrey

yes you would think that escpecially after i have researched the issue

I am on SQL Server 2005 Developer 64-bit 9.00.4053.00 SP3

I was able to...

No, as far as I know you cannot set up auditing this way. A central management server might be able to accomplish this, however I don't use one so I...

You can't use a computed column value in another computed column on the same table.

You'll need to just duplicate the code for those columns, such as:

select year(regdate) as [Year],month(regdate) as...

3 separate LUNs, each with its own partition. I usually don't create more than 1 partition per LUN.

As far as arrays, I'm not sure. I don't really have visibility into...