How do you troubleshoot if your tempdb gets filled

Answer Posted / sanjeev shekhar

use tempdb
go
sp_helpsegment "default"
go

Is This Answer Correct ?    4 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?

485


What is the difference between replication server and sql remote in sybase?

474


What are the operating systems in which sybase could take its presence?

478


How configure sybase odbc connection?

465


How can I execute dynamic sql with ase in sybase?

593






Must I use multiple devices to take advantage of partitions in sybase?

471


Differentiate between replication server and sql remote?

471


What mandatory options are required for bcp command utility?

506


Compare in and exists?

538


Explain mirroring?

488


Is there any advantage of last_name varchar(50) over this last_name varchar(255)?

566


Given a table which contains some rows with duplicate keys, how would you remove the duplicates?

467


Does sybase support row level locking?

443


What is table partitioning in sybase?

468


Explain the features of sybase.

552