摘要:
常用的dos命令,值得收藏:#1 一:net use \\ip\ipc$ " " /user:" " 建立IPC空链接net use \\ip\ipc$ "密码" /user:"用户名" 建立IPC非空链接net use h: \\ip\c$ "密码" /user:"用户名" 直接登陆后映射对方C:到本地为H:net use h: \\ip\c$ 登陆后映射对方C:到本地为H:net use \\ip\ipc$ /del 删除IPC链接net use h: /del 删除映射
阅读全文
posted @ 2012-03-02 13:16
杯中水_F
阅读(320)
推荐(1)
编辑
摘要:
-- Find DBs that have not been backed up in last 24 hourSELECT name AS database_name , backup_finish_date , coalesce(type,'NO BACKUP') AS last_backup_typeFROM( SELECT database_name,backup_finish_date, CASE WHEN type = 'D' THEN 'Full' WHEN type = 'I' THEN 'Differen
阅读全文
posted @ 2012-03-01 18:58
杯中水_F
阅读(179)
推荐(0)
编辑
摘要:
SET NOCOUNT ONDECLARE @c INTDECLARE @failed_jobs TABLE ( job_id uniqueidentifier, step_id int, step_name sysname, sql_message_id int, sql_severity int, message nvarchar(1024), run_status int, FailureDate datetime, server nvarchar(30))INSERT @failed_jobs(job_id, step_id, step_name, sql_message_id, sq
阅读全文
posted @ 2012-03-01 18:11
杯中水_F
阅读(620)
推荐(0)
编辑
摘要:
--得到最耗时的前N条T-SQL语句 --适用于SQL SERVER 2005及其以上版本 --给N赋初值为30 declare @n int set @n=30;with maco as (select top (@n) plan_handle, sum(total_worker_time) as total_worker_time , sum(execution_count) as execution_count , count(1) as sql_count from sys.dm_exec_query_stats group by plan_handle order by sum(t.
阅读全文
posted @ 2012-03-01 14:14
杯中水_F
阅读(368)
推荐(0)
编辑