SQL server不能远程连接

 What is SQL*Plus and where does it come from?
SQL*Plus is a command line SQL and PL/SQL language interface and reporting tool that ships with the Oracle Database Client and Server software. It can be used interactively or driven from scripts. SQL*Plus is frequently used by DBAs and Developers ......

Oracle维护常用SQL语句汇总
上一篇 / 下一篇  2008-09-04 11:25:01
查看( 1991 ) / 评论( 0 ) / 评分( 0 / 0 )
如何远程判断Oracle数据库的安装平台
select * from v$version;
查看表空间的使用情况
select sum(bytes)/(1024*1024) as free_space,tablespace_name
from dba_free_space
group by tablespace_ ......

在SQL Server2005/2008中可以使用一下四个命令来调优sql语句以及检查调优的结果
set
 statistics time on

set
 statistics IO on

set
 statistics profile on

set
 statistics xml on

......

SQL语句优化实践之一SQL_TRACE
 
环境：在PL/sql上调试数据
Pl/sql developer工具连接实例后即作为一个用户进程占用一个session；
 
select * from  v$session t  where t.PROGRAM='plsqldev.exe' and  t.USERNAME='DZJC'
查询结果显示了几个关键的字段
SADDR   RAW(4)  S ......

Sql代码:Powered by chenjiazi
--查询当天：   
select * from info where DateDiff(dd,datetime,getdate())=0   
  
--查询24小时内的:   
select * from info where DateDiff(hh,datetime,getDate())<=24   
  
--info为表名,datetime为数 ......