Wow. I started a war.

Do all of you realize that you are saying the same things, but in different contexts?

Security is not something simple, and to do it correctly...

I stand corrected.

BUT I also stand by the statement because unfortunately poor security seems to be the norm. It seems as if DBA's are so busy with everything else that...

Glad to help!

Good luck!!!

1. Take the call to xp_cmdshell out of the SP.

2. In the SP, test for the condition that would trigger the call to the batch file.

...

This is probably one of the "worst practices" in a trigger.

For starters, you need to elevate secutity.

Secondly, the amount of overhead that occurs with each Insert/update/delete is...

Becasue of this, and other situations that may be out of my hands, I never set up any SQL jobs to run at the top or bottom of an hour....

Have you looked at the Options in SSMS? Under "Tools", "Options", "Query Results", "Results to Text" what is "Maximum number of characters displayed in each column" set to? It...

Do you know why dropping and recreating makes things go faster, and they gradually slow down?

Do you have maintenance that updates statistics, and reindexes, if needed?

Plus, if the code within...

Don't do this! This is certainly not a first...

To change directions a bit, I am facing these same issues in the system I am working on. There are a number of places in the UI where the...

Handy, but it throws an error on a bit field because you cannot perform a min or max on them

I just bought a Subaru Outback 2 months ago. In 35 years of driving, this is the best vehicle I have ever owned.

I get 25 MPG running around, about...

After going through these same hoops, I simply created a stored procedure on the report server called usp_StartJobFromRemoteServer

This takes a job name or id as a parameter, and calls sp_start_job.

Remove this from the where clause and see if you still get a scan:

AND coalesce(txSubtype,'') <> 'BACKORDER'

Then, do a search on this site for SARGABLE.

Does this work?

UPDATE TBP

SET TBP.[Quantity_Remaining] = TBP.[Quantity_Remaining] - 1

FROM INSERTED I

INNER JOIN [tblTransactions] TT ON I.[Transaction_Number] = TT.[Transaction_Number]

INNER JOIN [tblBulkPurchases] TBP ON TT.[Transaction_Number] = TBP.[Transaction_Number]

WHERE TT.Transaction_Type = 'From Bulk...