Oracle SQL*Plus has a neat feature called AUTOTRACE, which enables us to get execution plan and additional statics about the running SQL statement. The main difference between AUTOTRACE and EXPLAIN PLAN is that AUTOTRACE actually executes the SQL statement. AUTOTRACE can be a helpful tool in Oracle Developer or Oracle DBA hands to check performance of SQL statements.

ORA-01536: space quota exceeded for tablespace is a common error in Oracle Database.
It means that users is trying to use more space than the Database Administrator assigned to him. Quota is a maximum number of bytes that a user can allocate in particular tablespace. Implementing quotas in database is a reasonable approach because it prevents buggy or malicious code to fill the tablespace.

Often we need quickly check the version of the Microsoft Sql Server. The quickest way to do it is to use @@VERSION. However there is one more method, which is often overlooked by Database Administrators, the extended stored procedure xp_msver.

Sometimes we want to disable user access to database without deleting or detaching that database. The easiest way to do it is to take database offline. Taking database offline can be performed using Transact-Sql or Sql Server Management Studio.

It is quite often asked question how to select only numeric data from character based column. Using Sql Server makes this task usually easy, you just need to use IsNumeric function.

create table t1( 

	c1 varchar(10) 

);




insert into t1(c1) values('Krystian');

insert into t1(c1) values('10');

insert into t1(c1) values('13.5');

insert into t1(c1) values('- 13.5');

insert into t1(c1) values('100.25.55');



select * from t1;



Krystian

10

13.5

- 13.5

100.25.55