All depends on your requirements.

Take a look at the stairways section of the site for great tutorials on both SSRS and SSIS

The problem is this column

[TWITTER].[SUBJECT] VARCHAR(20) NOT NULL,

Should that be

[TWITTER_SUBJECT] VARCHAR(20) NOT NULL,

Whats the full output of

DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS, TABLERESULTS

ram1447 (10/31/2015)

---

Hi all,

We use SQL server always on feather on my database and we distribute statement on main database server and mirror database server for raise performance.

My police for split...

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...