That's two :hehe:

Re: AWE on 32-bit...I thought you had to enable it if you wanted to enable LPIM, which also requires a trace...

Eugene Elutin (3/9/2012)

---

1. To check the count you do just this (you should try to make trigger as lightweight as possible):

if (select count(*) from inserted) > 20 -- change...

Matt Miller (#4) (3/8/2012)

---

<truncated>

True to a certain degree. That said, sending individual emails still is a cursor process, even if an asynch one. That's one thing you can...

Matt Miller (#4) (3/8/2012)

---

Eugene Elutin (3/8/2012)

---

OTF (3/8/2012)

---

Eugene Elutin (3/7/2012)

---

It's not a good design to email from a trigger. You're killing performance of update. If I would be MS i would...

Not security related, but relevant if you use the PowerShell subsystem in SQL Agent. Make sure you choose a proper number of PowerShell worker-threads for SQL Agent to allow to...

I am not sure if there is a classic-C++ class already built for you to pickup and use but Bulk Copy is freely available within the SQL Server Native Client...

We had the same problem. This may be relevant for your situation too: http://support.microsoft.com/kb/2002203

This summed it up for me:

"While I think selling is a skill, I think it's one more easily learned by a wider variety of the population."

The above statement is a...

William Plourde (3/5/2012)

---

opc.three (3/5/2012)

---

You may be re-inventing the wheel a bit. Depending on how unique your situation is you may be able to leverage some built-in features of SQL Server....

JQAllen (3/5/2012)

---

Change Data Capture and Change Tracking are useful for auditing, but these features are not the same thing as 'temporal modeling'. Among other things, they have no support for...

You may be re-inventing the wheel a bit. Depending on how unique your situation is you may be able to leverage some built-in features of SQL Server. Have you looked...

William Plourde (3/5/2012)

---

Yes, you are correct in everything you wrote. TableA and TableB are separate entities. Yes, this is a bad practice because it violates normalization rules. I...

Which version of the FW are you targeting? Check your SQLCLR assembly's references to make sure those exist on the server.

What you've described wanting to do is to assign two meanings to one column...not good. I will assume that TableA represents an entity, independent of the entity in TableB, otherwise...

If you're trying to DENY a permission from an application service account in the sysadmin server role then that login probably should not be in the sysadmin role. You need...