摘要：
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
怕提神
阅读(110)
评论(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
怕提神
阅读(83)
评论(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
怕提神
阅读(167)
评论(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
怕提神
阅读(120)
评论(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
怕提神
阅读(129)
评论(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
怕提神
阅读(218)
评论(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
怕提神
阅读(218)
评论(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
怕提神
阅读(176)
评论(0)
推荐(0)
浙公网安备 33010602011771号