The nice thing about the OUTPUT clause it that it doesn't require a trigger. A way to do what you are asking would be something like this:

DECLARE @orders TABLE...

If you have proper indexes performance should not be an issue because of joining tables. You need to determine how you are going to handle NULL or empty parameters...

A couple of options. Run sp_who2 to see if your insert is being blocked. You can also run Profiler to check for Blocking/Deadlocks or you can enable the...

You want to use the Data Conversion task.

I'd recommend moving the Express DB to the Standard edition server. You not only want to be able to schedule backups, but other maintenance tasks as well like DBCC...

Darn it Jeff, I know I have seen that solution somewhere before, don't know if it was by you or not, but I wish I would have remembered it.:-D

Just read in Grant's book, Chapter 8, that:

To limit contention with the operating system, I will usually set the max degree of parallelism setting to one less than the number...

Jan Van der Eecken (9/4/2009)

---

GilaMonster (9/4/2009)

---

Jan Van der Eecken (9/4/2009)

---

Anyhow, strange that the sore muscles I had from Wednesday's session seem to have magically (almost) disappeared after another session...

I don't think a page split caused by an update to a non-indexed column will affect the size of a non-clustered index, check this blog post by Paul Randal. ...

I got something working, but the question about -Filter and -Exclude still remains.

Thanks guys. Even Grant who hijacked the thread. Which is fine. Might as well...

Now to get back to my problem.

Okay, I think I may have identified my problem. I am attempting to archive Default Trace files and I was using this command:

Get-ChildItem...

I'm not sure what you want. I don't see any double spaces in the string you included. You may need to check for Tabs (Char(9)), Line Feeds (Char(10)),...

Updating a non-indexed column should not affect any indexes.

Is the distributor on the same server or another one?

Where and how are you setting @dbname? It sounds like you have issue there.