How to find out what is happening in a Database?
We have an old server that runs SQL Server 7 on an NT system. One database has processes running that are not documented. I have written triggers to report any deletions, inserts or updates made against the database's tables. All I can report is that an insert, update or delete has occurred, the...
View Answer
| Jul 14 2008 11:01 PM GMT
| asked by
Mjf7
SQL Server, Triggers, Unknown processes
Temp Tablespace in 10G
have a Oracle 10g database that is with its temporary tablespace full. Is there any way to clean this tablespace? I tried to restart the database, but i've no effect
View Answer
| Jan 14 2008 7:42 PM GMT
| asked by
DAC
Temp Tables, Oracle 10g
view and temp. table which one works better in T-SQL?
please tell me which one performs better view or temp table ?
View Answer
| Jan 5 2008 0:13 AM GMT
| asked by
HL
Oracle Views, T-SQL, Temp Tables
