摘要:
代码 Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->--setupUSE MASTERGO-- Create the server auditCREA 阅读全文
摘要:
#实例化对象,以SqlConnection为例子Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->$con=new-object System.Data.Sqlclient.SqlConnection("server=.;uid=xxx;pwd=xxx")#引用静态方法 Using Static Classes and MethodsCode highlighting produced by Actipro CodeHigh 阅读全文
摘要:
Can we remove a single query plan?You can use sp_recompile system stored procedure to clear it if the type of query plan is proc,trigger or functionElse you can't. If the received parameter of sp_reco... 阅读全文
摘要:
SET option make different compiled plan
For specific sql test, it always has the same sql_handle, but it may not always have the same plan_handle. If the cache keys change, we'll get a new plan_handle in plan cache. The relationship between sql_handle and plan_handle is thus 1:N 阅读全文
摘要:
This post was published to stswordman at 6:09:31 PM 4/14/2009 table scan against heap with forward pointer Sql server维护了一个内部指针,它指向了表的第一个IAM页,还有一个执行表的首页的内部指针对一个表(heap)执行table scan时,sql server会按照IAM顺序查找... 阅读全文