We can go with PartNumber + Location as Paul...

Paul White (2/21/2010)

---

Barry,

How would reversing the statements work? An INSERT might throw an exception if a key value already exists. Wrapping it in TRY...CATCH would work, but you...

And now, having said all this and gone all this way, I notice something that could make it all irrelevant. *sigh*

Sander: you said that the slower query...

Paul White (2/21/2010)

---

RBarryYoung (2/21/2010)

---

Paul White (2/21/2010)

---

...

Personally, I doubt the query is disk-bound; it is more likely that the rewrite introduced a spool of some kind, or is using a kind...

It's right. Trust me, I've been doing this for a looong time across many different environments and OSs, 20 years at least....

justpiyushmittal-1127780 (2/19/2010)

---

...Now when our application executes the stored procedure it gaves an error as mentioned in the subject line. Whereas the account running the stored procedure has sysadmin permission and...

What do you mean by "best"? ...

lmu92 (2/20/2010)

---

Paul White (2/20/2010)

---

...

I often hear the objection about not wanting to use CLR just for one thing 🙁

The trouble is, until you add one, the next one will always...

You just have you brackets a little bit off:

CREATE TRIGGER [dbo].[trg_manageTrailerInventoryHistory] ON [dbo].[TrailerInventory]

AFTER INSERT, UPDATE

AS

BEGIN

-- SET NOCOUNT...

Honestly I don't see this as a problem.

So we answer many of the same questions all the time, so what? Learning what these most common questions are...

CirquedeSQLeil (2/21/2010)

---

Actually creating a thread or forum is not the difficult thing by far.

The difficult thing is ensuring that people read it. Just like a Terms & Conditions Agreement...

This isn't the article I was thinking of, but it does have some perspective and approach for this: http://sqlblog.com/blogs/merrill_aldrich/archive/2009/10/29/using-historical-perf-counters-for-storage-planning.aspx

also, what kind of organization is this for? Business, academic, non-profit, Govt, NGO, ... ?

FYI: this is actually called "Storage Planning", as "capacity planning" has a very specific and completely different meaning for computer systems.

I do remember seeing some good storage planning articles a...

You might also want to check you tempdb and the Disk that it is on. One thing that might cause this is if it tried to expand tempdb, but...