n*******r
发帖数: 425 | 1 truncate ddl
delete is dml
"
truncate = delete + commit
except
no DML triggers will be fired in truncate
"
not true, truncate set hwm back to original points so it cleans up the space
immediately, unless you specify REUSE STORAGE clause |
|
l******9
发帖数: 579 | 2 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: Truncation error import csv file to SQL table
发信站: BBS 未名空间站 (Wed Apr 29 15:28:46 2015, 美东)
I would like to import a .csv file into a SQL Server 2008R2 database table
on Win 7.
It has one column and one row.
File1:
name
runeocnu 430274 sjunosnv djduenvop 934m ljfonm3
I got error:
Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data
conversion for column "NAME" returned status value 4 and status text "Text
w... 阅读全帖 |
|
h*********s
发帖数: 14 | 3 Hi,
I got confused about "truncation point move"...
1. secondary truncation point move only if submit to RS successfully (IBQ).
even if it has not commited?
or it should only move if apply to RDB successfully or OBQ succesfully (fully
commited)
2. when will primary truncation point move? After it commited in PDB? what
does " has finished processing." mean?
attached here is the info I got from Sybase Web site and fast track to rep
thank you very much,
********************************************* |
|
c*****d
发帖数: 6045 | 4 truncate table操作oracle要检查是否存在ref关系
如果有B表fk ref到你要truncate的表A,即便B表里实际没有数据,truncate A操作也不
能成功
delete就不同了,如果没有对应的数据,delete A操作可以 |
|
w*********e
发帖数: 5286 | 5 truncate = delete + commit
except
no DML triggers will be fired in truncate.
you cannot rollback, it removes all rows in a table, but not the schema,
privileges, etc.
truncate is usually much faster than delete cuz it does not need to save all
rows in undo space. |
|
l******9
发帖数: 579 | 6 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: Truncation error import csv file to SQL table
发信站: BBS 未名空间站 (Wed Apr 29 15:28:46 2015, 美东)
I would like to import a .csv file into a SQL Server 2008R2 database table
on Win 7.
It has one column and one row.
File1:
name
runeocnu 430274 sjunosnv djduenvop 934m ljfonm3
I got error:
Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data
conversion for column "NAME" returned status value 4 and status text "Text
w... 阅读全帖 |
|
p****l
发帖数: 23 | 7 【 以下文字转载自 Statistics 讨论区 】
发信人: propel (fitness water), 信区: Statistics
标 题: question about the sum of truncated normal rv
发信站: BBS 未名空间站 (Fri Jan 15 23:52:00 2010, 美东)
x and y are i.i.d normal, left-truncated at 0, with mean \mu and variance \
sigma. Is x+y normally distributed with mean 2\mu, variance 2\sigma and left
-truncated at 0?
thanks. |
|
y***e
发帖数: 39 | 8 LDF has all the transaction log, so it keeps growing when you use your
database. You can do a backup to truncate the log. There seems to be a setting
that let you to specify how many log files and how often you can have your log
file truncated. DBCC can help of course. |
|
c*****d
发帖数: 6045 | 9 不管delete还是truncate,都不会破坏数据库的结构
delete是dml,可以rollback
truncate是ddl,不可以rollback |
|
c*****d
发帖数: 6045 | 10 对,如果想truncate table A成功
必须alter table B disable constraint FK_NAME
然后就可以truncate A了
也不 |
|
n********6
发帖数: 1511 | 11 补充题外问题：
在sql server里面，如果在stored procedure里面用truncate，job agent run需要非
常高的权限。为什么呢？因为truncate是DDL吗？
结果是：很多都用delete，尽管有些数据可能不需要写入log file。 |
|
k*******1
发帖数: 22 | 12 truncate table了，column names, index, permission都还在的？？？
就是说如果truncate table了以后又想加入数据到这个table，就不用再create table
了，直接
insert就行？？ |
|
l******9
发帖数: 579 | 13 I would like to import a .csv file into a SQL Server 2008R2 database table
on Win 7.
It has one column and one row.
File1:
name
runeocnu 430274 sjunosnv djduenvop 934m ljfonm3
I got error:
Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data
conversion for column "NAME" returned status value 4 and status text "Text
was truncated or one or more characters had no match in the target code page
.".
(SQL Server Import and Export Wizard)
I have created the destination table
CRE... 阅读全帖 |
|
r******g
发帖数: 600 | 14 有full length，untagged 的对照～ 也有full length, tagged的对照～ molecular
weight没有问题
我没有克隆 untagged的 N-ter truncated protein 或者 C-ter trucated protein,
另外，没有争对 C-ter truncated region的 抗体
唯一的抗体 是对Nter的epitope |
|
p****l
发帖数: 23 | 15 x and y are i.i.d normal, left-truncated at 0, with mean \mu and variance \
sigma. Is x+y normally distributed with mean 2\mu, variance 2\sigma and left
-truncated at 0?
thanks. |
|
l*****i
发帖数: 43 | 16 以前proc surveymeans 不管variable的format有多长，都可以output，现在format如
果很长就被truncate了。
proc surveymeans data=aa nobs mean clm;
var xx;
domain yy;
strata pp;
weight ww;
run;
如果xx的format很长，比方说是this is a test code bbbbb,就被truncate成this is
a t.
我数了数，最多能output出12个字母。
大家有没有遇到这个问题？ |
|
a****g
发帖数: 8131 | 17 WARNING: Data too long for column；truncated to 92 characters to fit
如何使SAS不truncate，而是print整个column？
谢谢 |
|
A*******s
发帖数: 3942 | 18 Hi i have a question about SAS output. Suppose I have a lot of variables
whose names' length is up to 32. If I run any regression procedures the
output ParameterEstimates truncates the variables' name to length 20. How
should I change some settings to have SAS display the variables without
truncation? Many thanks. |
|
i*u
发帖数: 299 | 19 本图纯属个人意见
1. E.W.的rule of alternation基本上算是成立了，wave2 sharp, wave 4 sideways.
2. 由于wave 3特别强，而wave 1只是wave 3的1/6，wave 5应该是个truncation，那就
是说下一个大跌不会低于1100 for the SPX.
详细解说欢迎浏览以下网址 |
|
S**********s
发帖数: 4534 | 20 if they cost the same as HP, then they're not worth the money.
FMJ-TC or FN is like a jacketed version of SWC minus the sharp edge.
it will shoot somewhat nicer holes on paper like SWC. On flesh, the
difference is marginal from a RN, so, definitely not worth the extra money.
Some big game hunters prefer truncated bullets in their elephant guns but
that's really a whole other story. |
|
m******t
发帖数: 2416 | 21 It's supposed to truncate the log files once a while by default,
but it's somehow not happening on my system. Did anybody actually
get it working on 3.0 or 3.1? |
|
c**t
发帖数: 2744 | 22 SQL Server:
truncate table blah
vs
delete blah
which one is faster? and why? |
|
e******r
发帖数: 220 | 23 我想把所有数据从一个table里去掉, 先试了truncate,没成功(说是referenced
by foreign key); 用delete就成了.
什么原因啊? 在这个例子里, 用delete 会不会破坏数据库的结构?
谢谢 |
|
j***a
发帖数: 10844 | 24 And truncate will release the storage space. Delete won't. |
|
k*******1
发帖数: 22 | 25 "Neither the DELETE statement without a WHERE clause nor the TRUNCATE
TABLE statement affect the schema structure of the table or related
objects."
这里的“the schema structure of the table or related objects”是指什么啊？ |
|
|
c*****y
发帖数: 75 | 27 truncate 不写入log
delete 是一条一条删除 可以恢复的 |
|
t********k
发帖数: 808 | 28 truncate = delete + commit ?
are you sure?
truncae also changes the high watermark |
|
m**y
发帖数: 18546 | 29 一个很简单的truncate statement，平时都很快就能run 完了，今天一直run都不结束
。别的
select statement 都没事。可能是什么原因啊？ |
|
n****e
发帖数: 1403 | 30 MySQL table either insert or drop/truncate table running forever ?
engine=innodb,
innodb_file_per_table
What is the possible reason?
Thanks |
|
n****e
发帖数: 1403 | 31 How to check lock-wait situation?
Even when I restart the linux server and restart the MySQL server and do
insert/truncate the same issue appear again,
Thanks |
|
b***i
发帖数: 3043 | 32 其他电脑上可以看到该applet，也能看到我存到微软officelive上同一个网页的另一个
网上找的applet，是个原子核外电子绕着转那个
我的电脑上ie可以看，firefox不能，也不能看到原子那个，就看到java调入那个转圈
的图案，然后弹出窗口，有时说truncated class file，有时说class not found. 但
是，firefox可以看到sun的例子applet,比如那个小企鹅翻跟头那个。
还有sun的那些例子如果是jnlp文件也是可以的。
这是怎么回事呢？ |
|
r******g
发帖数: 600 | 33 看到 很多大牛们出来讨论 那个克隆的问题～ 我也来征求一下大家的suggestions～
我们实验室 研究一个 mitochondrial protein的功能。 是一个mitochondrial
transmembrane protein。我的实验目的 是，克隆表达 这个蛋白的 5'-HA tag-Nter
region-Transmembrane-3' (缩写HA-Nter clone) 和 5'-HA tag-transmembrane-C-ter
region-3' (HA-Cter clone) 两个truncated protein.
clone挺简单，因为 克隆cDNA，并且，蛋白很小，只有200氨基酸。我克隆的片段也挺
小的，没有经历太多难度。我把 Nter clone 和 Cter clone 都克隆到 一个
retroviral vector，coding region后面有一个IRES-GFP。plasmid 8.6kb。
接下来,我把这个HA-Nter clone 和HA-Cter clone，用293 cell 表达（CaCl2
transfection）.
... 阅读全帖 |
|
r****y
发帖数: 1437 | 34 For a real matrix A, its condition number is cond(A) = x, suppose
x is a very large number.
Do SVD, let A = U*S*V'. If A is (m, n) matrix, U is (m, m) unitary
matrix, V is (n, n) unitary matrix, and S(m, n) diagonal matrix and
s11 >= s22 >= s33 ...
Truncated SVD means now let A1 = U(m, k) * S(k, k) * V(n, k)', where
k
But does it always true that cond(A') <= cond(A)?
Thanks in advance.
|
|
m******t
发帖数: 273 | 35 【 以下文字转载自 Statistics 讨论区 】
发信人: myregmit (myregmit), 信区: Statistics
标 题: long time generating gamma distribution in python
发信站: BBS 未名空间站 (Thu Mar 13 19:04:24 2014, 美东)
I need to generate a truncated gamma distribution pdf curve and histogram in
python 3.
2 on win7.
import numpy as np
import matplotlib.pyplot as plt
import scipy.special as sps
shape, scale = 2., 2. # mean and dispersion
counter =0
s = []
upper_bound = 4
lower_bound = 0.5
while (counter <= 1000):
t = np.random.gamma(shape, ... 阅读全帖 |
|
m******t
发帖数: 273 | 36 【 以下文字转载自 Statistics 讨论区 】
发信人: myregmit (myregmit), 信区: Statistics
标 题: long time generating gamma distribution in python
发信站: BBS 未名空间站 (Thu Mar 13 19:04:24 2014, 美东)
I need to generate a truncated gamma distribution pdf curve and histogram in
python 3.
2 on win7.
import numpy as np
import matplotlib.pyplot as plt
import scipy.special as sps
shape, scale = 2., 2. # mean and dispersion
counter =0
s = []
upper_bound = 4
lower_bound = 0.5
while (counter <= 1000):
t = np.random.gamma(shape, ... 阅读全帖 |
|
e****c
发帖数: 183 | 37 【 以下文字转载自 Mathematics 讨论区 】
发信人: ecosoc ( ), 信区: Mathematics
标 题: 一个normal distribution 加一个truncated normal distribution 是什么distribution？
发信站: BBS 未名空间站 (Tue Mar 17 22:08:24 2009)
比如一个 N （0，alpha)。另一个N (x, beta), 但是这第二个distribution 只在s 和
t 之间。这两个distribution 加起来，是什么样子？ |
|
l*********1
发帖数: 66 | 38 mixed Gaussian distribution.(with one truncated?) |
|
b*******g
发帖数: 513 | 39 虽然我猜就是一个自变量除去0的truncated poisson分布。但还是不太确定。感觉有些
东西不能从字面上联想。知道的同学，麻烦告诉一声，多谢！ |
|
s*********e
发帖数: 1051 | 40 in a standard poisson, zero outcome has nonzero probability.
the zero-truncated poisson is a standard poisson with zero probability of
zero outcome. |
|
c****s
发帖数: 63 | 41 Code:
data house.classmention;
set house.classmention classmention1;
run;
Log中出现的错误：
Warning: At least one data value for column M may have been truncated.
Maximum length of data encountered during input was 41.
请教怎么fix 这个问题，万分感谢！ |
|
F****3
发帖数: 1504 | 42 要用zero-truncated negative binomial regression分析panel data，想加几个fixed
effect。
请问SAS里面怎样实现啊？如果没有fixed effect我是用proc fmm。谢谢！ |
|
m******t
发帖数: 273 | 43 I need to generate a truncated gamma distribution pdf curve and histogram in
python 3.2 on win7.
The following program is correct ?
import numpy as np
import matplotlib.pyplot as plt
import scipy.special as sps
shape, scale = 2., 2. # mean and dispersion
counter =0
s = []
upper_bound = 4
lower_bound = 0.5
while (counter <= 1000):
t = np.random.gamma(shape, scale)
if (lower_bound <= t <= upper_bound) :
s.append(t)
counter += 1
count, bins, ignored = plt.hist(s, 50, normed... 阅读全帖 |
|
b*********s
发帖数: 6757 | 44 发信人: NJ08807 (三脚猫@bridgewater), 信区: Tennis
标 题: Re: 2014 MITBBS 网球版排行榜
发信站: BBS 未名空间站 (Sat Apr 26 00:29:11 2014, 美东)
Truncation 是指如果对手积分差大于0.48， 就算0.48。
Expected Game Difference = 12。 因为两盘局分差不会比12更大。
IRS = min(0.48, max(-0.48, IRS))
------------------------------------------------------------------
发信人: NJ08807 (三脚猫@bridgewater), 信区: Tennis
标 题: Re: 2014 MITBBS 网球版排行榜
发信站: BBS 未名空间站 (Sat Apr 26 00:36:26 2014, 美东)
开始积分差 0.98， implies 24.5 局分差
如果用truncate to 12 局 算0.48 分。 实际局差10局 （12-2）。
Adjust... 阅读全帖 |
|
b*********s
发帖数: 6757 | 45 发信人: NJ08807 (三脚猫@bridgewater), 信区: Tennis
标 题: Re: 2014 MITBBS 网球版排行榜
发信站: BBS 未名空间站 (Sat Apr 26 00:29:11 2014, 美东)
Truncation 是指如果对手积分差大于0.48， 就算0.48。
Expected Game Difference = 12。 因为两盘局分差不会比12更大。
IRS = min(0.48, max(-0.48, IRS))
------------------------------------------------------------------
发信人: NJ08807 (三脚猫@bridgewater), 信区: Tennis
标 题: Re: 2014 MITBBS 网球版排行榜
发信站: BBS 未名空间站 (Sat Apr 26 00:36:26 2014, 美东)
开始积分差 0.98， implies 24.5 局分差
如果用truncate to 12 局 算0.48 分。 实际局差10局 （12-2）。
Adjust... 阅读全帖 |
|
b*********s
发帖数: 6757 | 46 发信人: NJ08807 (三脚猫@bridgewater), 信区: Tennis
标 题: Re: 2014 MITBBS 网球版排行榜
发信站: BBS 未名空间站 (Tue Apr 22 22:46:25 2014, 美东)
写了一个具体的implementation这样可以谈的具体。。
网络上容易鸡鸭对话， 还是具体点有例子好谈。
黑导， kennyD， jjch， acc 看看framework如何？
原始帖方法看上去太长。。 我做了归纳。
http://tt.tennis-warehouse.com/showthread.php?t=468318
#input.rating: Input rating pair in descending order
# The first is higher
#DG The difference of games between the first
# and second player
#k: Multiplication factor.
... 阅读全帖 |
|
b*********s
发帖数: 6757 | 47 发信人: NJ08807 (三脚猫@bridgewater), 信区: Tennis
标 题: Re: 2014 MITBBS 网球版排行榜
发信站: BBS 未名空间站 (Tue Apr 22 22:46:25 2014, 美东)
写了一个具体的implementation这样可以谈的具体。。
网络上容易鸡鸭对话， 还是具体点有例子好谈。
黑导， kennyD， jjch， acc 看看framework如何？
原始帖方法看上去太长。。 我做了归纳。
http://tt.tennis-warehouse.com/showthread.php?t=468318
#input.rating: Input rating pair in descending order
# The first is higher
#DG The difference of games between the first
# and second player
#k: Multiplication factor.
... 阅读全帖 |
|
m******t
发帖数: 273 | 48 【 以下文字转载自 Quant 讨论区 】
发信人: myregmit (myregmit), 信区: Quant
标 题: how to do data fitting to find distribution
发信站: BBS 未名空间站 (Sat Mar 15 11:02:05 2014, 美东)
Hi,
I need to do data fitting to find the distribution of a given data.
I need to find the pdf funtion of the distribution.
I can use data fitting functions in matlab and python.
It looks like a truncated gamma.
But, how to find the paramters of the distribution ?
What if the data cannot fit the truncated gamma well ?
The QQ-plot (qunatile-qua... 阅读全帖 |
|
N*****7
发帖数: 1899 | 49 写了一个具体的implementation这样可以谈的具体。。
网络上容易鸡鸭对话， 还是具体点有例子好谈。
黑导， kennyD， jjch， acc 看看framework如何？
原始帖方法看上去太长。。 我做了归纳。
http://tt.tennis-warehouse.com/showthread.php?t=468318
#input.rating: Input rating pair in descending order
# The first is higher
#DG The difference of games between the first
# and second player
#k: Multiplication factor.
# Original method uses 0.5; KennyD revision uses 0.25
#doMA: Whether including current rating again ... 阅读全帖 |
|
H****s
发帖数: 301 | 50 这个问题不是太好回答。
（1）。你这个基因是不是膜蛋白？如果全长蛋白和truncated isoform都是膜蛋白的话
，你的选择是做cDNA免疫大鼠或者是小鼠，然后用细胞表面表达全长蛋白和truncated
isoform的细胞来做筛选。这个过程大概需要3-6个月，看做事的人的效率和运气。
（2）。如果不是膜蛋白，并且你可以表达和纯化这两个蛋白。你的选择有以下两种：
第一种：用truncated isoform免疫大鼠或者是小鼠，然后通过杂交瘤的方法来筛选符
合你要求的抗体。这个抗体很可能识别由于truncation所造成的构象变化。这个过程大
概也需要6个月，看做事的人的效率和运气。
第二种：如果你有资源和人脉，可以使用体外抗体展示的技术（比如，噬菌体展示或者
是酵母展示）。这个应该比较简单一些。这个过程大概需要3个月，看做事的人的效率。
如果你实验室不缺钱的话，就找两个做抗体的CRO，在谈条件的时候说好，拿不到你需
要的抗体不付钱就行了（这招有点损，版上开公司的同学可能会不高兴）。如果我是你
，我会选择这个。因为你可以花时间去做真正的科学研究，而不是把你的时间都浪费在
创造实验条... 阅读全帖 |
|
