Exists Function - MDX Query

In MDX query is we want to find that particular set or tuples exists in the given second set ,we can use this function
If we provide optional measure group then it will also check the tuples has non NULL data in that measure group

How to delete job history - sp_purge_jobhistory

sp_purge_jobhistory
We can use this procedure to delete old history for jobs.

Troubleshooting Database Mail

Here I am giving some step to troubleshoot Database Mail related problems

Cant find sp_send_dbmail procedure
This procedure is in MSDB database.

sp_addlinkedsrvlogin - To modify or add new login on linked server

sp_addlinkedsrvlogin

To modify or add new login for linked server