摘要：
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
怕提神
阅读(131)
评论(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
怕提神
阅读(292)
评论(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
怕提神
阅读(166)
评论(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
怕提神
阅读(294)
评论(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
怕提神
阅读(149)
评论(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
怕提神
阅读(124)
评论(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
怕提神
阅读(151)
评论(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
怕提神
阅读(227)
评论(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
怕提神
阅读(148)
评论(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
怕提神
阅读(107)
评论(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
怕提神
阅读(178)
评论(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
怕提神
阅读(85)
评论(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
怕提神
阅读(138)
评论(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
怕提神
阅读(122)
评论(0)
推荐(0)
摘要：
math-liu， 一个甲方的DBA，同时他还有另外一个名字“怕提神”。在某甲方工作的他最近这几年如打了鸡血一般工作起来完全由拼命三郎的那股劲，据说能唯一使他感到一丝鼓励和安慰的是以下这两位大牛前辈。 一天math-liu被告知选上了优秀员工被奖励5000大洋但需要在宴会上做个演讲。本该激动不已的他 阅读全文
posted @ 2020-02-16 20:15
怕提神
阅读(110)
评论(0)
推荐(0)
摘要：
也不知道什么时候就被赶到这条路上来了，只听领导的一声令下，备份啊能不能在异地也存一份呀？？ 啊？？ 领导语重心长的说你看啊，我们这个备份是这个样子的 现在的南京的两个工厂备份要在对方留一份备份的存档，当一边挂了之后可以从另外一边恢复出来.! 天哪这个不就是备份的DR嘛，可是咱 没有做过呀? 后来 作 阅读全文
posted @ 2020-02-16 20:12
怕提神
阅读(951)
评论(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
怕提神
阅读(96)
评论(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
怕提神
阅读(100)
评论(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
怕提神
阅读(142)
评论(0)
推荐(0)
摘要：
This is xxxxx Because MES guy mistaken , the data was wrong and made system error then. After that I plan to set "autocommit off" in sqlserver as defa 阅读全文
posted @ 2020-02-16 19:48
怕提神
阅读(195)
评论(0)
推荐(0)
摘要：
EMC networker nmm can restore and recover sqlserver as different name to different location That is true. However, we should select this oprtions when 阅读全文
posted @ 2020-02-16 19:47
怕提神
阅读(203)
评论(0)
推荐(0)
摘要：
At first, this is not my article. He did But I want to tell you some are good and some are not necessary.OK , Here we begin: We need to generate sp_Bl 阅读全文
posted @ 2020-02-16 19:44
怕提神
阅读(640)
评论(0)
推荐(0)
摘要：
He is my test step: In a test enviroument, I make a table "test"/ demo table:create table test ( a nvharchar(100)); trigger record table:CREATE TABLE 阅读全文
posted @ 2020-02-16 19:39
怕提神
阅读(117)
评论(0)
推荐(0)
摘要：
n some circumstances, we just want to truncate transaction log without backup and refuce change database mode to "Simple".You may want to say "You are 阅读全文
posted @ 2020-02-16 19:27
怕提神
阅读(106)
评论(0)
推荐(0)
摘要：
If we want to make some identiity value in sqlserver , we can use identity data type in a table.However, there are some disadvantages on that style,Bu 阅读全文
posted @ 2020-02-16 19:26
怕提神
阅读(114)
评论(0)
推荐(0)
摘要：
Yes , in SQLSERVER, we use "DBCC sqlperf(logspace)" to check transaction logfile status.But , for example , we collect it every one hour and save resu 阅读全文
posted @ 2020-02-16 18:42
怕提神
阅读(133)
评论(0)
推荐(0)
摘要：
Unlike in Oracle, sqlserver has an special data type in order by make identity growth. But what about if the number is exceed or approaching the limit 阅读全文
posted @ 2020-02-16 18:27
怕提神
阅读(182)
评论(0)
推荐(0)
摘要：
How to make as map two or more device located in the same media pool by using ddboost + nw ? That is not easy but is possible. But you may ask why nee 阅读全文
posted @ 2020-02-16 18:25
怕提神
阅读(147)
评论(0)
推荐(0)
摘要：
script: select a.TABLE_NAME,a.COLUMN_NAME,a.DATA_TYPE, (CASE a.DATA_TYPE when 'int' then 'limited between -2147483648 and 2147483647' when 'bigint' th 阅读全文
posted @ 2020-02-16 18:20
怕提神
阅读(158)
评论(0)
推荐(0)
摘要：
Yes . In the previous. chapter , we see how to generate "partition function" "parttiton schema" and "parttiton table" what can we do if we need to add 阅读全文
posted @ 2020-02-16 18:16
怕提神
阅读(131)
评论(0)
推荐(0)
摘要：
The filegroup is similar as tablespace in Oracle. At first, I will show that hot to check file amd filegroup check filegroup: select a.name as "File g 阅读全文
posted @ 2020-02-16 18:10
怕提神
阅读(177)
评论(0)
推荐(0)
摘要：
The previous chapter is tell us how to install sqlerver on linuix Today, we will see how to make it work. Firstly, we need to install install UNIXODBC 阅读全文
posted @ 2020-02-16 18:08
怕提神
阅读(115)
评论(0)
推荐(0)
摘要：
Hello The MS open the source to let people download source. You may ask where to download ? Ask google yourself. Now here we begin: Unlikely other way 阅读全文
posted @ 2020-02-16 18:04
怕提神
阅读(84)
评论(0)
推荐(0)
摘要：
check process script 1, check which is current running: use master SELECTspid,ER.percent_complete,CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as va 阅读全文
posted @ 2020-02-16 18:02
怕提神
阅读(168)
评论(0)
推荐(0)
摘要：
Like a tratitional database, sqlserver not only could resotre full database but also do restore one part of it. There are two important base physical 阅读全文
posted @ 2020-02-16 18:01
怕提神
阅读(121)
评论(0)
推荐(0)
摘要：
demo/* add partitions */ alter database xxx add filegroup FG_=fff_201708;alter database xxx add file (name = FG_fff_201708,filename = "M:\DATA\SQLDATA 阅读全文
posted @ 2020-02-16 17:59
怕提神
阅读(130)
评论(0)
推荐(0)
摘要：
I can not believe that I had done this about two years Now we know there is totally different between oracle parttion table and sqlserver partition ta 阅读全文
posted @ 2020-02-16 17:58
怕提神
阅读(219)
评论(0)
推荐(0)
摘要：
Dear all, Let get into business, the partitions on sql server is very different with that on oracle. I do not want to speak too much, Here is an examp 阅读全文
posted @ 2020-02-16 17:57
怕提神
阅读(219)
评论(0)
推荐(0)
摘要：
On Love Then said Almitra, "Speak to us of Love." And he raised hs head and looked upon the People and here fell stillness upon them. And with a great 阅读全文
posted @ 2020-02-16 17:49
怕提神
阅读(162)
评论(0)
推荐(0)
摘要：
Last time, we talk about separate under one cluster backup into two diffetent AG backup. Does it works ? How is it ? Let we it this time: Unfortunatel 阅读全文
posted @ 2020-02-16 17:47
怕提神
阅读(109)
评论(0)
推荐(0)
摘要：
A NW NMM backup sqlserver failed. wow , I realze that maybe I put too many database backup together at one time. plan to separate it into two backup p 阅读全文
posted @ 2020-02-16 17:40
怕提神
阅读(178)
评论(0)
推荐(0)
摘要：
Oracle RAC is an share everything database architecture. The article is how to check out why virtual ip can not be switched to original version. You a 阅读全文
posted @ 2020-02-16 17:30
怕提神
阅读(128)
评论(0)
推荐(0)
摘要：
This is all begins from a mail. ... Dear sir: This is liulei. Thanks for your help about last PM for data migration to SSD storage. However, it is sti 阅读全文
posted @ 2020-02-16 17:29
怕提神
阅读(181)
评论(0)
推荐(0)
浙公网安备 33010602011771号