这篇文章主要介绍了MySQL replace into 语句浅析（一）,本文讲解了replace into的原理、使用方法及使用的场景和使用示例,需要的朋友可以参考下
Continue Readingdbcc 大全
dbcc 大全
Continue ReadingSQL Server 2005 – Default Trace (默认跟踪)
SQL Server 2005 – Default Trace (默认跟踪)在我们的工作中可能会遇到这样一种情形。由于数据库中某些对象被altered/created/deleted，造成我们的应用程序crash。
Continue Reading
谈谈基于SQL Server 的Exception Handling
谈谈基于SQL Server 的Exception Handling
Continue ReadingSQL Server 2008中SQL增强之一：Values新用途
SQL Server 2008中SQL增强之一：Values新用途
Continue ReadingSQL Server 2008中SQL增强之二：Top新用途
SQL Server 2008中SQL增强之二：Top新用途
Continue ReadingBe ready to drop your indexed view.
Be ready to drop your indexed view.In all-too-many cases an indexed view may solve your short term performance goals but at some later time become counterproductive. So if you choose to use an indexed view, you may need an exit strategy. Let me describe a few common problems with indexed views.
Continue ReadingSQL Server 2008中原生的分层数据类型：hierarchyid
SQL Server 2008中原生的分层数据类型：hierarchyid
Continue Reading监控SQL Server的运行状况(1)
监控SQL Server的运行状况(1)
Continue Reading
SQL Server 負載平衡架構介紹(Load Balancing)
SQL Server 負載平衡架構介紹(Load Balancing)
Continue Reading