Industrial patois... Well played.

I didn't know 24 hour old data in SSAS was real time analytics. That's going on the ol' resume!

The restrictions are there to make it easy to compile into straightforward (read "fast") code. When you're writing these, just imagine how you would write the same thing in...

In addition to learning a little and putting it into immediate practice, which most everyone has mentioned, I find it useful to draw on the same point from as many...

I've often found it helpful to stage every column as a character type. Invariably something ends up where it shouldn't. For a small number of columns that can...

I agree with what you have here, Miles. When I looked into the concept of using queueing for a problem I wanted to solve, it sounded like a perfect...

Found this thread trolling for answers to the same question. Here's what works for me.

exec msdb.dbo.sp_send_dbmail

@profile_name = 'YOUR_PROFILE',

@Recipients= 'YOUR_EMAIL',

@Subject= 'sample message with attached query',

@Body= 'sample...

Thank you for giving this problem a try. It seems you're the only one who wanted to give this a try. However, this is exactly the solution I...

Does ternary logic have the same rule that allows me to to say that the above is logically equivalent to

if 1!=0 or 1!=null

If so, I'm back where I...

This second table summarizes the...