Just following up... here's a cool problem that I just ran across that I was able to answer because I'd done something like it before...

Here's the problem...

You have a payment...

Absolutely concur!  I was just demonstrating one method of getting the CPU time expended by a single spid.  I usually get the I/O the same way as well as measuring...

Reet,

You'll undoubtably get several suggestions using a self-joined correlated sub-query which are usually pretty darned slow.  They'll usually take about 29 seconds to do 10,000 records and the duration get's exponentially...

To summarize your request for a view to simply reject those things where "somecolumn" has things in it besides numeric digits...

CREATE VIEW dbo.someviewname

    AS

SELECT somecolumns...

Ummmm.... press the {f8} function key...

Thought I'd throw one of my own into the circle...

If you don't have a "Tally" or "Numbers" table, now is as good a time as any to make one.  A...

Jacques,

I'm not sure how your example helps because the cpu time you produce is for the entire server, not an individual spid... as you said about simple elapsed time, if...

I have to admit... I've never seen an ideally designed database  (usually, too many cooks in the design with too little knowledge, you know...

I'm thinking that's likely true because, as someone else pointed out, the TEMPDB database is set to the "SIMPLE" recovery mode.  However, most other operations on temp tables are logged......

If I understand the problem correctly... this might be a good job for a trigger.

... of course, there are no possibilities when you don't respond to the people trying to help.

Does anyone have a Microsoft reference or test code to support that one?  I'm kinda in the "Myth Buster" mode at work about Temp Tables and Table Variables... anything you...

Simple obfuscation using Exclusive-OR is fine for keeping the honest man honest...

But one of the first things hackers do on an SSN column is something like this...

1.  Take a...

SG,

We can help but we need to see some examples of the dates... as you can see from the posts above, there are a lot of possibilities...

Wow, Mark... that's quite the laudry list...

There are many solutions (and caveats as Tim pointed out) to your list of nice-to-haves... if you do a search on this site, I'm...