-
Stable Device
What do you mean by Stable Device in Sybase replication?
mikeob
- Jun 17th, 2009
I think the textbook term is 'stable queue' - the place on disk where transacitons/data is stored until it reaches its destination(s). Plays the role of a ledger file in JMS/Tibco.
-
How the blocker processes exist internally in sybase
deepaish
- Aug 16th, 2009
You can execute the stored procedure sp_who , this will give you process id which is blocking what. This is more usefull since sometimes user doesn't have restricted permission for master database.
mikeob
- Jun 17th, 2009
One can look at master.sysprocesses blocked column to look at what is blocking what.
-
Why can a user create 249 non clustered indexes over a given table as against only one clustered index over a table?
rachitkhanna1981
- Sep 1st, 2009
When 1 clustered index is being formed on a table then the values when entered into the table have to be in the same form or there would be an error message whereas nothing of this sort is being used in non clustered index therefore more then 1 could be created.
harish_varghese
- Jun 11th, 2007
With a clustered index, Adaptive Server sorts rows on an ongoing basis so that their physical order is the same as their logical (indexed) order. Since we can maintain data in any one order only, there can be only one clustered index per table as against 249 non-clustered indexes.
-
How to find out the maximum sales of an item for each sales man.The table consists sales_man, item, sales columns, each sales man will have the different sales values for different items.here I have to find out for every sales man, which item he sold maximum
nagaraju_p
- Sep 9th, 2009
Select a.sales_person, a.item, a.TotalQuantityFROM (select b.sales_person,b.item,SUM(b.InvAmount ) as TotalQuantity from sales_data bGroup by b.sales_person,b.item)as aGROUP BY a.sales_personHAVING a.TotalQuantity = MAX(a.TotalQuantity )
swadheengupta
- Sep 8th, 2008
Assuming that both the items are required to be shown if two or more items are sold of same quantity. The query is :-select sales_man,item,sales from table where (sales_man,sales) in? (select sales_man,max(sales) from table group by sales_man);
-
What is a deferred update in sybase?
nagaraju_p
- Sep 9th, 2009
Deferred update is donewhen the updated row does not fit in the same pagewhen the updated row needs to change information on the index pagewhen there is a subquery in the table joinwhen the update happens to the primary key which is being referenced by other foriegn keys.
JamesMike
- May 5th, 2007
Deferred updates are carried out by adaptive server. Generally in deferred updates the affected rows are analyzed and further updations needed on these rows are carried out by the adaptive server. In ...
-
A column name is given to you. You have to find out which table has that column. Database has 230 tables. For example: empid (column name) For this how do you find out which table has the column (empid) ?
nishusingh84
- Oct 8th, 2009
SELECT DISTINCT o.name FROM sysobjects o,syscolumns cWHERE o.id=c.id ANDc.name='empid' --- or you can go for c.name LIKE "%empid%"
-
Replication Thread
How will you handle when an replication thread goes down?
Rep_dba
- Apr 1st, 2010
Check Replication server error log to see why the thread is down. Fix the error and resume the thread. If it is DSI thread that is down, run following command in Rep server.resume connection to data_server.database
-
Replication Exception Log
What is exception log in replication?
Rep_dba
- Apr 1st, 2010
Skipped transactions and orphaned transactions in replication server are logged into Exceptions log. Exception log is set of three RSSD tables rs_exceptshdr, rs_exceptscmd, rs_systext. You can run rs_helpexception to see the exceptions.
-
Master Database Size
What are the default size of master database in sybase ?
ravi.marennavar
- May 21st, 2010
It depends on your logical page size of serverif logical page size is 2K-master db will be of 13mbif 4k - 26mbif 8k - 52mb
Satsun
- Apr 24th, 2009
The default size of a master database in sybase is 6MB for a 2K page size Adaptive server.
-
How is Workspace used in Sybase?
anubhashjain
- Jun 18th, 2010
Workspaces are special tables in dbccdb that store intermediate results of the dbcc checkstorage operation. Workspaces differ from worktables in that they: -- Are preallocated contiguously ...
-
What is the major differences between Oracle & Sybase
chrisjej
- Jun 23rd, 2010
I would point out that the above answers are point in time - and any answer should mention the versions involved. Sybase is a company - not a database server, by the way. The question should be asking...
tuliothx
- Jul 5th, 2008
Let me clarify that while Sybase does not have "Object Tables" it can hold BLOBS in columns in tables. These can be of datatype TEXT or IMAGE.Sybase has the concept of Temporary tables in the form of ...
-
Which one is faster count(*) or count(1) ?
-
How can you change to get the decimal separator as comma instead of the decimal point (.)?
protech
- Jul 15th, 2010
declare @mod_string varchar(20)select @mod_string = str_replace("1234.567",".",",")select @mod_string
debadritab
- Jun 24th, 2008
declare @source varchar(30)
select @source = "10.236.155.17"
while charindex(".",@source) > 0
begin
select @source = stuff(@source,charindex(".",@source),1,",")
end
select @source -
How to multiply all values of a single column.
samala_naresh
- Aug 7th, 2008
Declare @var intselect @var = 1update set @var = @var*< colname >select @var
-
There are 2 tables, Employee and Department. There are few records in employee table, for which, the department is not assigned. The output of the query should contain all th employees names and their corresponding departments, if the department is assigned otherwise employee names and null value in the place department name. What is the query?
suresh1_saxena
- Aug 6th, 2010
The query for this question can be written by using the outer join.select?* from employee a,department b where a.emp_id*=b.emp_id
kevinkpatel99
- Feb 21st, 2010
ANSI Syntax:SELECT Emp.ENAME, Dept.ENAMEFROM Employee Emp left join Department DeptON Emp.DEPTNO = Dept.DEPTNOTransact-SQL Syntax:SELECT Emp.ENAME, Dept.ENAMEFROM Employee Emp, Department DeptWHERE Em...
-
Query Plan
How does Sybase system decide on which plan to use for a query? Can you force a plan to be used by the Sybase system
-
How to clear tempdb when the tempdb gets filled?
dychandran
- Oct 6th, 2010
We may need to identify the Culprit Spid Which is casuing the Tempdb to filled up and confirm about the is that ok to kill it and clear the log.use dbcc log - Commad to identify the Cuprit Spid.dbcc logPurpose: displays transaction log records.
jaya
- Nov 24th, 2007
Dump tran with truncate_only if it is not cleared the go for select lct_admin("abort", {process_id [, database_id]})
-
Query Performance Tuning
What parameters would you look for while trying to optimise your query? How is the cost of a query measured
subi_sybase
- Dec 20th, 2010
Do a set showplan oncheck each query and see if any table scan is used....if yes, check if any index is present on tables...if index is not present try adding it....if index is present, determine what...
-
Db Space
How do you check db space and what are the measures available to increase the db space?
subind123
- Mar 4th, 2011
Measure available to increase the DB space:1) Drop objects which are no longer used.2) Run alter database command to increase database size.
nagaraju_p
- Sep 9th, 2009
Sp_helpdb gives information about memory used and available.sp_spaceused - gives space used..
-
Given a table which contains some rows with duplicate keys, how would you remove the duplicates?
krishna kanth
- Apr 14th, 2011
Set rowcount 1delete from mytable where (select count(*) from Mytable group by col1 having count(*)>1)>1while(@@rowcount0) delete from mytable where (select count(*) from Mytable group by col1 having count(*)>1)>1set rowcount 0go
gcvpgeek
- Mar 3rd, 2009
We can do remove the duplicate records using the below single queryDelete from table1 where rowid not in (select max(rowid) from table1 group by dup_col)
Sybase Interview Questions
Ans