The other part that caught my attention was:

Do all emails come...

I think that is the answer, the server refuses to take the message. My first guess would be that the message is too big. ...

HanShi makes great points and is correct.

Also I don't think the SQLCMD command line program has a SQLCMD mode like SSMS does. But that isn't used quite as much anyway...

The command SQLCMD is a command line interface to SQL, you type in SQL commands and type GO and it does them. It also allows you to execute a set...

It is my understanding that the system databases get upgraded when SQL starts for the first time with the new (updated) binaries. It can tell internally that the system...

Are you referring to the command SQLCMD vs the Management Studio or SQLCMD mode in Management Studio?

CEWII

I would consider it 2 complete SQL installs, except that the point to a single set of system and user databases. So in that regard yes there are two. ...

You have two installs of the binaries for SQL, one on each node, the databases are available to only a single node at a time. So no you don't have...

You cannot build and execute dynamic SQL within a function.

CEWII

Provided Sean is on the right track you need to get a certificate and install it, once that is done you can configure SQL to allow it. With just...

As for your internal exchange I'm sorry but you have me baffled as well..

For GMail that is a little tricky BUT they are pretty straightforward..

Here is what I have used:

I...

Just a minor clarification, your memory could be being used frequently BUT the pages that it needs to satisfy the queries are already in memory so it doesn't have to...

In SQL you can't build dynamic SQL and execute it as part of a function. So as far as that is concerned you can't.

As far as the dynamic sql you...

The lower limit on that number is the subject of much speculation, I particularly like the number 300 for many servers.

Understanding what that number means is important, basically it is...

I find that those professional rules/code of conduct are often not lived up to with little or no repercussions and therefore arguing that they provide something more than symbolic value...