Data
Database Mail is stopped. Use sysmail_start_sp to start Database Mail. PDF Print E-mail
All in One - Data
Written by Administrator   
Monday, 05 July 2010 21:34

This stored procedure starts the Database Mail queue that holds outgoing message requests and enables the Service Broker activation for the external program.

Solution : 
USE msdb ;
GO

EXECUTE dbo.sysmail_start_sp ;
GO
Last Updated ( Monday, 05 July 2010 21:39 )
 
ORA-30926: unable to get a stable set of rows in the source tables PDF Print E-mail
All in One - Data
Written by Administrator   
Monday, 15 February 2010 15:42

Cause

When you use merge statement

Action

 You have to check primary key constraint for two tables in merge statement.

 

 
 
excel 2007 vlookup multiple PDF Print E-mail
All in One - Data
Written by Administrator   
Wednesday, 18 November 2009 23:29
=IF(ISNA(VLOOKUP(J7;$M$7:$M$1682;1;FALSE));"0";"1")
 
ORA-06519 active autonomous transaction detected and rolled back PDF Print E-mail
All in One - Data
Written by Administrator   
Tuesday, 15 September 2009 07:22
in procedure or pl-sql block you have to add commit or rollback
 
Oracle tuning tips PDF Print E-mail
All in One - Data
Written by Administrator   
Friday, 14 August 2009 07:19

Use Exists instead of IN

dont use : 27 seconds

select count(*) from pro 
where pro_id in
( select  pro_id from sales)


OK : 20 seconds

select count(*) from pro p
where exists
      ( select 1 from sales s
          where s.pro_id=c.pro_id

 

*

index should be created in different tablespace with table

 
Last Updated ( Tuesday, 25 August 2009 06:43 )
 
More Articles...
« StartPrev12NextEnd »

Page 1 of 2