./freetds/freetds.conf:/etc/freetds.conf:rw # 确保 :rw 可读写。Adminer 安装mssql sqlserver php 驱动；adminer 安装pdo_dblib mssql;这个版本的镜像不用自己安装驱动了。耗时一个美好的周六下午。

sql log bloghttp://rusanu.com/2014/03/10/how-to-read-and-interpret-the-sql-server-log/http://killspid.blogspot.com/2006/07/using-fndblog.htmlRecover_Deleted_Data_With_UID_Date_Time_ProcI

http://blogs.msdn.com/b/bartd/archive/2007/07/19/are-you-using-sql-s-missing-index-dmvs.aspxSELECT migs.avg_total_user_cost * (migs.avg_user_impact / 100.0) * (migs.user_seeks + migs.user_scans) A

common.ps1cls; #Global is public#Script is internal#Script is Script#Local is current stack level#Numbered scopes are from 0..N where each step is up to stack level (and 0 is Local)$

1.sqlserver 2008 R2 on windows server 2008 R2群集中，有节点A、B，现在需要停机新添加一个节点C进来替换现有节点B，请列出必要的步骤.2.sqlserver 2008 R2 on windows server 2008 R2群集中，有节点A、B，A节点内存比B节点内存大一倍，为当前的主节点，为了业务需要，需要释放A节点内存即重新启动sqlse

IF OBJECT_ID('t_merge_gomac_avpickmap', N'TR') IS NOT NULLBEGIN PRINT 'Dropping Trigger t_merge_gomac_avpickmap' DROP TRIGGER t_merge_gomac_avpickmap IF @@ERROR = 0 PRINT 'Trigger

USE [msdb]GO/****** Object: StoredProcedure [dbo].[kill_elapsed_job_by_name] Script Date: 2017/9/26 16:09:27 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO CREATE PROCEDURE [dbo].[k