Ellie's blog

新增Disk至SQL FCI後， 若無法從SSMS看見新增的Disk，有可能是Resource漏了設定Dependencies

啟用或停用WSFC 節點的投票權

若AG裡的各replica位於不同subnet，建立SQL listener遇到Error 19456

Linked servers cannot be used under impersonation without a mapping for the impersonated login

錯誤碼為: 0x851A0044

Replication with DB Mirroring

摘要:Replication between 2008R2 and 2012

摘要:SQL 2012 installation

摘要:Mirroring VS Log Shipping

摘要:SQL Error Log

摘要:MERGE vs. INSERT/UPDATE 效能比較

remote query timeout / 設在client 端

摘要:SQL健檢

摘要:Rebulid master 以重設伺服器collation

Subsystem % could not be loaded 或 error:c001f001

Subsystem % could not be loaded 或 error:c001f001

摘要:SQL 2000 + SP3, MSDB TargetServersRole

摘要:找出有使用某一特定物件的stored procedure, view, trigger, constraint.....

摘要:同一連接(Session)建的暫存物件都在 tempdb，故無法用 schema

Create index 與 IntelliSense 的 deadlock