06 2014 档案

SQL Server 2012 新的分页函数 OFFSET & FETCH NEXT
摘要：DECLARE @page INT, @size INT;select @page = 300, @size = 10SELECT *FROM gpcomp1.GPCUSTWHERE company like 'a%'ORDER BY CUSTNOOFFSET (@page -1) * @size ... 阅读全文
posted @ 2014-06-27 11:51 princessd8251 阅读(378) 评论(0) 推荐(0) 编辑
How to delete expired archive log files using rman?
摘要：he following commands will helpful to delete the expired archive log files using Oracle Recovery Manager(RMAN).Connect to the Rman prompt and try the ... 阅读全文
posted @ 2014-06-25 15:04 princessd8251 阅读(733) 评论(0) 推荐(0) 编辑
Oracle利用external table 查看trace文件
摘要：1. 用下面的语句找到trace文件的路径select * from v$diag_info where name='Default Trace File';2. 创建一个directory用来加载trace文件create or replace directory tracefile as '/u... 阅读全文
posted @ 2014-06-10 00:57 princessd8251 阅读(421) 评论(0) 推荐(0) 编辑
SQLServer User and Login Tips
摘要：use masterIF EXISTS (SELECT * FROM sys.databasesWHERE name = 'gpdb83sp')BEGINDROP DATABASE gpdb83spEND;CREATE DATABASE gpdb83spON( NAME = gpdb83sp_dat... 阅读全文
posted @ 2014-06-10 00:49 princessd8251 阅读(563) 评论(0) 推荐(0) 编辑
DMV to track the temp file usage for SQLServer
摘要：There are three DMVs you can use to track tempdb usage:sys.dm_db_task_space_usagesys.dm_db_session_space_usagesys.dm_db_file_space_usageThe first two ... 阅读全文
posted @ 2014-06-10 00:39 princessd8251 阅读(236) 评论(0) 推荐(0) 编辑
convert Timestamp to Real time
摘要：select r.ring_buffer_address,r.ring_buffer_type,dateadd (ms, r.[timestamp] - sysinfo.sqlserver_start_time_ms_ticks, sysinfo.sqlserver_start_time) as r... 阅读全文
posted @ 2014-06-08 20:48 princessd8251 阅读(454) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示