Chris,

Great reference, that clears up the whole conversation 😀

Couldn't you accomplish the same thing with extended events?

What Hugo said.

I agree, Rich. Just pointing out where some of the confusion may have originated. 🙂

Apparently, not everyone thinks that sp_who2 is total disk I/O (reads and writes).

http://www.devx.com/tips/Tip/14208

A useful, illustrative question. Thank you, Wayne!

PMDB is the project management database in P6, most likely the database of interest to you. P6 can use either Oracle or SQL Server as a backend database. If you...

+1

This may be a stupid suggestion but here goes anyway:

If you create 2 views - one with

Select Stuff FROM WELLS INNER JOIN on everything else

WHERE (where clause stuff)

and another...

Apologies to Chrissy for butting in again, but to add:

On all of my applications, I have a "Splash" screen to announce certain information to the user at startup. I set...

I can 2nd Chrissy321's approach as valid. I'm using something very similar. One piece of advice (is discussed also in article referenced by Chrissy321) is to locally store the tabledef...

I'm with the folks who say that concantenating two strings is @input, not a separate "parameter". We need to be using the common definition of parameter here.

The comment about [Me] being out of context for the data source is correct. That can be modified by using the following syntax: [Forms]![FormName]![Text41]

In the AfterUpdate event for Text41, you...

Deleted (missed next page of posts :hehe:)

Sometimes I want to keep a "history" of the different settings, or have more than one set depending on circumstances. In these cases, I use a "current" column (bit) to...