摘要：
Thanks to The advisor show us that we can get different behavior when we use condition , ='20000' or N'20000' CODE/*+++++++++++++++++*/set nocount ong 阅读全文
posted @ 2020-02-16 20:29
怕提神
阅读(104)
评论(0)
推荐(0)
摘要：
Thanks to MS sql could have materialized views ,similar with oracle MVs, using indexed views. what is going on ? are they same thing ? Here we go : (1 阅读全文
posted @ 2020-02-16 20:26
怕提神
阅读(175)
评论(0)
推荐(0)
摘要：
In sqlserver, it is impossible that if we want to create an function index. Doesn`t means we can not ? Father said there always a way. That is virtual 阅读全文
posted @ 2020-02-16 20:23
怕提神
阅读(84)
评论(0)
推荐(0)
摘要：
Unlike AWR in Oracle, Sqlserver does not have offical way to make history performance information for checking. until today. I made it. you can deploy 阅读全文
posted @ 2020-02-16 20:19
怕提神
阅读(133)
评论(0)
推荐(0)
摘要：
Dear all: I had put "partition_show" before . but this time it makes faster. partition_show: SET ANSI_NULLS ONGO SET QUOTED_IDENTIFIER ONGO create vie 阅读全文
posted @ 2020-02-16 20:18
怕提神
阅读(109)
评论(0)
推荐(0)
摘要：
math-liu， 一个甲方的DBA，同时他还有另外一个名字“怕提神”。在某甲方工作的他最近这几年如打了鸡血一般工作起来完全由拼命三郎的那股劲，据说能唯一使他感到一丝鼓励和安慰的是以下这两位大牛前辈。 一天math-liu被告知选上了优秀员工被奖励5000大洋但需要在宴会上做个演讲。本该激动不已的他 阅读全文
posted @ 2020-02-16 20:15
怕提神
阅读(109)
评论(0)
推荐(0)
摘要：
也不知道什么时候就被赶到这条路上来了，只听领导的一声令下，备份啊能不能在异地也存一份呀？？ 啊？？ 领导语重心长的说你看啊，我们这个备份是这个样子的 现在的南京的两个工厂备份要在对方留一份备份的存档，当一边挂了之后可以从另外一边恢复出来.! 天哪这个不就是备份的DR嘛，可是咱 没有做过呀? 后来 作 阅读全文
posted @ 2020-02-16 20:12
怕提神
阅读(935)
评论(0)
推荐(0)
摘要：
Some times we suddently find that the NMC can not login,. You would see the sybase database error if you try to find reason..Does it means difficult ? 阅读全文
posted @ 2020-02-16 20:01
怕提神
阅读(92)
评论(0)
推荐(0)
摘要：
Simple step for EMC NW & NMM (1) disable WINDOWS UAC (reboot)(2) SET windows domain user AS sysadmin(3) modify hosts(4) install software (NW , NMM) (r 阅读全文
posted @ 2020-02-16 19:56
怕提神
阅读(93)
评论(0)
推荐(0)
摘要：
As we said, sqlsever fail over cluster is perviously version of always on. The HA was guarenteed by OS not database. Therefor, we can not use windows 阅读全文
posted @ 2020-02-16 19:50
怕提神
阅读(134)
评论(0)
推荐(0)
浙公网安备 33010602011771号