If you have the licenses to cover the cores in use then yes.

SA gives a bunch of different features like a single passive failover node, upgrades etc.

But as long as...

RECOMPILE

select a.* from a inner join b on a.id = b.id option (recompile)

Needle

Take a look at sys.fn_hadr_is_primary_replica, its written to return true false depending which node in the group is the primary.

Also these two links may help

http://sqlmag.com/blog/alwayson-availability-groups-and-sql-server-jobs-part-7-detecting-primary-replica-ownership

http://sqlmag.com/blog/alwayson-availability-groups-and-sql-server-jobs-part-8-dynamic-detection-gotcha-1

Always On Failover Cluster

or

Always On Availability Groups on a Always On Failover Cluster

Always On is just a marketing term, generally dropped as it means nothing really, so generally detail if...

On the trace imported disable event requirement checks, that always works for me

Your ReplyTo is @To, that needs to be @From

Also not a fan of sp_OA calls, they use memory outside of the SQL allocation, have you looked at converting this to...

Snapshots create sparse files. So as data changes, the original data is pushed into the sparse file to ensure the snapshot is a snapshot of that time it was...

Thread

There is also the hidden same drive scenario also.

Is the drive split into multiple partitions? EG a 500GB drive split 250GB / 250GB labeled with different drive letters. ...

Sure there will be a better way to do it than a cursor.

Could you please provide definitions of the tables in question, with some sample data and an expected outcome.

Please...

Please don't cross post questions, it fragments replies.

http://www.sqlservercentral.com/Forums/Topic1732107-3411-1.aspx

Warning can be skipped, errors cannot.

Your installing SQL on a server edition that has Windows Firewall, it is warning you that you must change the firewall settings in order to...

You running any server audits?

Would be a string concatination due to needing the H in the middle.

Something like

select

rowid,

datemeeting,

RIGHT('00'+convert(varchar(2),hoursmeeting),2) +'H'+ RIGHT('00'+convert(varchar(2),minutemeeting),2)

from @tbl