摘要：
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
怕提神
阅读(193)
评论(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
怕提神
阅读(202)
评论(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
怕提神
阅读(114)
评论(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
怕提神
阅读(105)
评论(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
怕提神
阅读(113)
评论(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
怕提神
阅读(130)
评论(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
怕提神
阅读(146)
评论(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
怕提神
阅读(155)
评论(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
怕提神
阅读(130)
评论(0)
推荐(0)
浙公网安备 33010602011771号