Are the parameters actually dynamic, or are they always 1/1/thisyear and Today?

If you absolutely insist on having a Where clause, but want all the rows, use:

Where 1 = 1

Eric Russell 13013 (10/26/2010)

---

This why I keep saying that some type of identifier unique to each instance of the application or user, like client_id or cashregister_id, when combined with a...

Eric Russell 13013 (10/26/2010)

---

Paul White NZ (10/25/2010)

---

NEWSEQUENTIALID calls the Windows API function UuidCreateSequential, which uses...

Are you looking for something that will select all the start and end dates for months between 1 Jan and the current date?

If so, can't you just select the first...

Steve Jones - SSC Editor (10/26/2010)

---

Each trigger adds to the transaction time since it is included in the transaction that is doing the update. That can impact performance as locks...

If yes, don't have a Where clause.

Today's XKCD is definitely worth a look. (It has some "NSFW language" in it.)

Your question isn't all that clear.

Do you want all the rows in a table?

It looks to me like what you need to do is change the parameter values. What am I missing?

If by "all the items" you mean you want all the rows in a table, you can get that most easily by not having a Where clause at all. ...

Memory pressure in SQL can best be measured by using Performance Monitor or any of a variety of third party tools.

Start with this: http://msdn.microsoft.com/en-us/library/aa905152(SQL.80).aspx

I can't tell what you're asking. Can you clarify your question?

Take a look at the Output clause for SQL 2005/2008. That should give you what you need.

There almost has to be at least a little performance impact, simply because of having to call each trigger causing memory and CPU use. That's probably trivial.

The main thing...