-
-
-
Avoid Data Changes
How to avoid Data changes while retrieving data?
-
Database BackUp
How will you take database backup when there is no space in file system?
ericpro
- Nov 21st, 2014
You can also try using remote backup so you can dump to another server with available space. of course you have to configure the interfaces between the servers to allow this.
-
Sybase ASE server Display the number value in Words
I need to convert a "check amount" to a "written out amount in english", for check printing.
Ex) $ 582.71 ---> Five hundred eighty two and 71 cents
-
Sybase Stored Procedure and Triggers
What is the maximum nesting level of Stored Procedure and Triggers in Sybase?
neo.sql
- Sep 10th, 2011
The default option for maximum nesting level is 16 however this is a server configurable value and can be lesser than this also. To check the current maximum nesting level for stored procedures and tr...
-
What is Sybase SQL Server?
neo.sql
- Sep 10th, 2011
Sybase SQL Server is the RDBMS developed by Sybase Inc (now an SAP company) which is now called as Sybase Adaptive Server Enterprise is the enterprise version and a flagship product of Sybase. Another...
luisgranados
- May 20th, 2011
Is the original name for the product we know today as Adaptive Server Enterprise.Sybase SQL Server name was changed since version 11.5 because they wanted to differentiate the product from Microsoft.
-
Sybase Prefetch
What is the significance of the keyword 'prefetch' in SQL queries?
Tejas More
- Jul 7th, 2011
prefetch improves performance by anticipating the pages required for certain well-defined classes of database activities whose access patterns are predictable. The I/O requests for these pages are iss...
-
Add Not Null Column in a Table
How we can add a NotNull Column in a table by using alter command (without using default command)?
Tejas More
- Jul 7th, 2011
You can add a NOT NULL column to a table. This means that a constant expression, and not a null value, is placed in the column when the column is added. This also ensures that, for all existing rows, ...
UncaAlby
- Oct 20th, 2008
First add the column as NULL. Then populate the column with non-null data. Then modify the column to NOT NULL. You may need to set dboption "select into" to True.
-
Views 'with check' Option
What is the use of 'with check' option in views?
Tejas More
- Jul 7th, 2011
The with check option flag prevents insertion or updating of rows that will not meet the view criteria. e.g.: create view cal_publishers_chk as ...
dhampack
- Nov 24th, 2008
When you create a view using the with check option clause, each insert and update through the view, is validated against the views selection criteria. If the rows inserted or updated are out of cri...
-
How to clear the logsegment when the Secondary truncation point is on ?
luisgranados
- May 20th, 2011
I suppose you want to do that because you refresh the database to a development/QA environment and you no longer need the replication to be working.So you just need to disable the secondary truncation...
dhampack
- Nov 24th, 2008
There are only two options to clear the log1) Kill the tran which is filling up the log2) Extend the transaction log to complete the transaction.don't use 'dump with truncate_only' if you ...
-
Secondary Truncation Point
What is Secondary Truncation Point?
luisgranados
- May 20th, 2011
Is a mark in the primary db log up to which the replication agent has processed transactions.
-
How to get the list of tables in Sybase?
Read Best Answer
Editorial / Best Answer
rlbafna- Member Since Mar-2008 | Mar 12th, 2008
sp_help - lists all objects (including tables and views)
List if Views : select name from sysobjects where type = "V"
rlbafna
- Mar 12th, 2008
Sp_help - lists all objects (including tables and views)
List if Views : select name from sysobjects where type = "V"keerthv
- Apr 21st, 2007
Select name from sysobjects where type="U"This gives the list of user defined tables in the current database.
-
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)
-
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..
-
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...
-
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 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
-
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...
-
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
Sybase Interview Questions
Read Best Answer
Ans