摘要：
MSSQL is good database. Unlike as Oracle, it seems that can not backup sqlserver databasee tables one by one. However there is always way. Thanks to I 阅读全文
posted @ 2020-02-16 20:56
怕提神
阅读(129)
评论(0)
推荐(0)
摘要：
Dear all , This is liulei , I was back so , How to add VTL tapes on DD6300 & label them into "Oracle_VTL" pool ? In DD6300, each time we can just add 阅读全文
posted @ 2020-02-16 20:54
怕提神
阅读(279)
评论(0)
推荐(0)
摘要：
Yes, thanks to Then, I can give simple and reasy way to make it. Suppose hosts and IPs like that: 150.150.186.16 linux3 (primary)150.150.186.26 linux4 阅读全文
posted @ 2020-02-16 20:50
怕提神
阅读(162)
评论(0)
推荐(0)
摘要：
During DBA career, the hard time is who , when and where did touch data from tables. It would take much resources that if we would use object or datab 阅读全文
posted @ 2020-02-16 20:49
怕提神
阅读(282)
评论(0)
推荐(0)
摘要：
Yes, we can get information from mssql by using excel vba. But the default port of MSSQL is 1433. what about if the port number was changed ? Does it 阅读全文
posted @ 2020-02-16 20:45
怕提神
阅读(155)
评论(0)
推荐(0)
摘要：
That is true. Vmware is easy and confortable tools to make vitrual machines than Oracle virtual box. But Oracle vitrual box is free to use and vmware 阅读全文
posted @ 2020-02-16 20:41
怕提神
阅读(143)
评论(0)
推荐(0)
摘要：
Dear buddy, Have you confuse that how activity about my databases, if we conside it by using backup size about archive files(oracle) and transaction l 阅读全文
posted @ 2020-02-16 20:37
怕提神
阅读(120)
评论(0)
推荐(0)
摘要：
Dear : If you have to use EMC NW NDMA to backup oracle database and want to see what happen when backup failed. You can use this wau and do not do tha 阅读全文
posted @ 2020-02-16 20:34
怕提神
阅读(141)
评论(0)
推荐(0)
摘要：
Dear all Yes ~ We can backup our sqlserver by EMC NW NMM. That is true and NW is a very very powerful and useful backup software. Why we use enterprse 阅读全文
posted @ 2020-02-16 20:33
怕提神
阅读(223)
评论(0)
推荐(0)
摘要：
Dear all You may remember that my blog has a view script for checking sqlserver partition tables. Now , it`s oracle version comes. script select part. 阅读全文
posted @ 2020-02-16 20:31
怕提神
阅读(143)
评论(0)
推荐(0)
摘要：
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号