Need to write a sybase monitor for alerting on table scanning processes. Is there a way of running this stored proc that does not require sa_role? Tried reloading just the text into another datab...
http://www.experts-exchange.com/Database/Sybase/Q_23315869.html
Zones:
SybaseDate Answered: 04/14/2008 Rating: 9.9 Views: 0
The SQL statement produces a result with more than two number to the right of the decimal place.
select Round(((rp.Act_Part_Cost * rp.Quantity) + (rp.Act_Labor_Hours * rp.Act_Labor_Rate) + rp.T...
http://www.experts-exchange.com/Database/Sybase/Q_23323546.html
Zones:
SybaseDate Answered: 04/15/2008 Rating: 9.8 Views: 0
Will there be any impact in Sybase performance in installing MDA tables
http://www.experts-exchange.com/Database/Sybase/Q_23910716.html
Zones:
SybaseDate Answered: 11/26/2008 Rating: 7.6 Views: 4
why do we need a transaction log or logsegment for tempdb?? All the objects in tempdb are flushed during a server recycle so why do we need a transaction log?? A transaction log records updates/del...
http://www.experts-exchange.com/Database/Sybase/Q_23975791.html
Zones:
SybaseDate Answered: 12/20/2008 Rating: 9.1 Views: 25
Hi
I am trying to bcp in a set of records from a comma separated file. I use the the format file that is attached as a code snippet. The code snippet section also has a sample row from my test f...
http://www.experts-exchange.com/Database/Sybase/Q_23981437.html
Zones:
SybaseDate Answered: 12/14/2008 Rating: 6.4 Views: 0
While debuggig a proc, i found that a sql block for creating and inserting values in to a #table is performing wierdly.
The sql block below when ran with variable is fetching the result in 18 min...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23720122.html
I am trying to execute the following query which comprises of 2 tables sbe_order_reporting and #cust.
select distinct o.client_Data,
"D",
@loopDate
from sb...
http://www.experts-exchange.com/Database/Sybase/Q_23726682.html
Hi,
This is a question for Incisive but anybody can contribute :-)
You mentioned in a previous response something regarding statistics. I don't think my question was fully answered. Let me t...
http://www.experts-exchange.com/Database/Sybase/Q_23953327.html
Zones:
SybaseDate Answered: 12/03/2008 Rating: 9.2 Views: 0
Hi,
I've read a chapter from the P&T Sybase manual on denormalization which goes into the nitty gritty but i think i missed the fundamental concepts so i was hoping some1 can shed some light pl...
http://www.experts-exchange.com/Database/Sybase/Q_23955521.html
Zones:
SybaseDate Answered: 12/03/2008 Rating: 9.0 Views: 0
Hi,
On the topic of 'Optimising Joins' I would like to know how joins are processed by the Query Optimiser and how it decides the join order...
Again, an example would be nice to clear up th...
http://www.experts-exchange.com/Database/Sybase/Q_23955671.html
Zones:
SybaseDate Answered: 12/05/2008 Rating: 9.4 Views: 0
