C****n
发帖数: 2324 | 1 My database is 512M, my LDF is 3.4G, it's ridiculous! |
|
y***e
发帖数: 39 | 2 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. |
|
s*********e
发帖数: 1051 | 3 > n <- 1000000
> set.seed(2013)
> ldf <- data.frame(id1 = sample(n, n), id2 = sample(n / 100, n, replace =
TRUE), x1 = rnorm(n), x2 = runif(n))
> rdf <- data.frame(id1 = sample(n, n), id2 = sample(n / 100, n, replace =
TRUE), y1 = rnorm(n), y2 = runif(n))
>
> # METHOD 1: MERGE
> system.time(join1 <- merge(ldf, rdf, by = c("id1", "id2")))
user system elapsed
54.028 11.229 65.673
>
> # METHOD 2: PLYR
> # library(plyr)
> # system.time(join2 <- plyr::join(ldf, rdf, by = c("id1", "id2"), type =... 阅读全帖 |
|
m*******g
发帖数: 3044 | 4 just run SAS, got error message:
ERROR 22-322: Syntax error, expecting one of the following: GROUP, HAVING,
ORDER, WHERE.
ERROR 76-322: Syntax error, statement will be ignored.
318
319 where
320 b.moend=ldf.monthend and
321 b.ay=ldf.ay;
322 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
my code is :
proc sql;
create table sasuser.aggloss_mcr... 阅读全帖 |
|
e*******c
发帖数: 2133 | 5 目前在看health reserving的东西，有点疑问。首先，health reserving和p&C
reserving很像，但又有不少区别。比如p&C reserving里会有reported（incurred)
loss, paid loss的区别,还会要考虑p/i ratio.比如比较新的munich chain ladder就
是可以缩小p/i ratio的一个方法；但是，在health里好像没有reported loss这个概念
，只有paid loss,然后自己算completion factor(就是1/LDF,财险里的reported %（好
像是啊）),然后用paid loss/CF算出来estimated incurred loss,也就是说人家都用不
上munich chain ladder这么有技术含量的东西。
再有个小疑问就是健康险里算completion factor我觉得又不太像1/ldf,好像是1/(LDF1
*LDF2*LDF3....LDFn),关键是ldf这里已经是cumulative loss的了，再乘起来就挺奇怪
的了。举个数字的例子吧：1... 阅读全帖 |
|
c***s
发帖数: 70028 | 6 莱昂纳多在联合国气候峰会演讲中大谈气候变暖等环保问题。但随即有媒体却指出他在气候变暖问题上有着“双重标准”，莱昂纳多本人频繁依靠私人飞机出行。
莱昂纳多·迪卡普里奥与潘基文
本年度联合国气候峰会周二在纽约联合国总部开幕，上周日曾跟超过40万人一起走上纽约街头游行，表达反全球暖化诉求的莱昂纳多·迪卡普里奥(小李)，换上正装在开幕式上发表致辞。
莱昂纳多在演讲中敦促国际社会采取行动，控制大气污染以及减少碳排放量。但随即有媒体却指出，这位39岁的好莱坞影星似乎在气候变暖问题上有着“双重标准”，他频繁依靠私人飞机出行、租用大型游艇外出游玩等行为，都难以与“环保减排”画上等号。
呼吁政要行动：我以演戏为生，你们不是
莱昂纳多周二在联合国气候峰会的演讲开场说道：“作为一名演员，我以演戏为生。我扮演虚构人物，常常解决虚构的问题。我认为人类过去对气候变化抱有类似的看法，好像它是虚构的、是发生在某个其他星球上的事，好像只要装作没这回事，它就会自己消失不见。”
他随即表示，现在大家对气候变化的认识要比以前多了很多，因为大家每周都会看到不可否认的事实，包括干旱加剧、海洋变暖及酸化、海底甲烷气体外溢等，我们目... 阅读全帖 |
|
z*****a
发帖数: 3809 | 7 【 以下文字转载自 NewYork 讨论区 】
发信人: beefcurtain5 (beefcurtain5), 信区: NewYork
标 题: To make elite schools ‘fair,’ city will punish poor Asians
发信站: BBS 未名空间站 (Mon Jul 21 05:43:04 2014, 美东)
In 2004, 7-year-old Ting Shi arrived in New York from China, speaking almost
no English. For two years, he shared a bedroom in a Chinatown apartment
with his grandparents — a cook and a factory worker — and a young cousin,
while his parents put in 12-hour days at a small laundromat they had
purchased on the Upper East... 阅读全帖 |
|
b**********5
发帖数: 7881 | 8 In 2004, 7-year-old Ting Shi arrived in New York from China, speaking almost
no English. For two years, he shared a bedroom in a Chinatown apartment
with his grandparents — a cook and a factory worker — and a young cousin,
while his parents put in 12-hour days at a small laundromat they had
purchased on the Upper East Side.
Ting mastered English and eventually set his sights on getting into
Stuyvesant High School, the crown jewel of New York City’s eight “
specialized high schools.”
When he was ... 阅读全帖 |
|
e*******c
发帖数: 2133 | 9 "关键是ldf这里已经是cumulative loss的了"我指的是age to ultimate LDF.ATU
factor不就是把所有的ldf乘一块吗？换句话说每一个age的cumulative loss/ultimate
loss=report %(CF in Health reserving),然后1/report %=ATU LDF.
不知您能不能先讲讲incurred loss和paid loss的区别和p/i ratio的事 |
|
R*****g
发帖数: 99 | 10 这两个地方有嫌疑：
1.
sasuser.claims_m b
sasuser.ldf （改为 sasuser.ldf ldf ?）
2. select a/b as calculated c? 不太记得这个地方要不要用calculated了，很有可能跟别的什么搞混了。。。[确定了，这种情况是不需要的，即使需要也不是用在这里，是用在where语句]
不过好像这两个都不是跟错误信息提示的内容相关的。等cow人们来更正 |
|
R******s
发帖数: 16 | 11 Hi, All,
I would like to join this family. As a new member, I wish everybody has a
wonderful career journey and would like to share my experience with you in
the future.
I would like to ask help as well, if you have some experience in the loss
development factor (LDF) analysis. Recently I got a project regarding how
to grouping the territorial LDFs. One idea is based on ANOVA, however, I don
't know how to start it. Have you guys has such experience, what do you
usually do?
Thanks a lot! |
|
G*****u
发帖数: 1222 | 12 p&c里面也不是全用reported losses
需要看line of business以及数据的可靠性
"关键是ldf这里已经是cumulative loss的了"?这句话怎么理解 没看懂
ldf全称是loss development factor
在triangle里面是通过当月的loss(either paid or incurred) 除以前月的loss
是一个ratio 怎么会是cumulative loss
关于你health insurance completion factor计算那段 很可能是你弄错了
我以前见过一些health reserving triangle
和P&c reserving triangle排列的朝向不太一样
但是最终计算结果应该是相同的 |
|
e*******c
发帖数: 2133 | 13 Question: Is reported loss totally dependent on paid loss?If so, then P/I
ratio is just 1/(ATU LDF), since incurred loss=paid loss*(ATU LDF) |
|
d***o
发帖数: 3770 | 14 大学营养学实验室找我做实验，研究健康食品主要是高钾食品对轻微高血压的治疗效果
。我想有吃有喝有钱赚，还能降血压，何乐而不为？就参加了。吃了他们的食品然后躺
在床上测血压心跳和LDF，1个多小时都不能动。1个洋妞女学生帮我测量，她长着1张清
纯的娃娃脸，宽松的羊绒衫下双峰突起，紧身的牛仔裤上有两道破缝，露出少女青春富
有弹性的肌肤。连声音都是那样甜美可人。我躺在那里假装闭眼睡觉，趁她不注意从她
宽松的上衣下摆处偷窥。可惜心跳血压却骗不了人，比平时都高。她问我：Why have
your blood pressure and heart rates increased so much? 我也问她：Why are you
so sexy and pretty? 问得她哑口无言。兴奋紧张让我憋了1大泡尿，还不能去上厕所
。躺着一动不动还不如我在冰天雪地里铲雪骑自行车好玩，这种罪以后还是不受为好。 |
|
w******u
发帖数: 5413 | 15 这样说来小弟的桌面最高级。。
一个40x40的硬木桌面从中间裁开，替换了房子自带workbench的LDF，所以bench现在尺
寸20x80。。 |
|
a********a
发帖数: 3082 | 16 对，sauder的便宜家具就是LDF加便宜塑料纹纸 |
|
w****r
发帖数: 245 | 17 大侠，分类都分好了，求神签
# Basic Materials, Agricultural Chemicals
AGU Agrium Inc.
AVD American Vanguard Corp.
CAGC China Agritech Inc.
CF CF Industries Holdings, Inc.
CGA China Green Agriculture, Inc.
CMP Compass Minerals International
COIN Converted Organics Inc.
IPI Intrepid Potash, Inc.
MON Monsanto Co.
MOS Mosaic Co.
NOEC New Oriental Energy & Chemical
POT Potas... 阅读全帖 |
|
M*****8
发帖数: 17722 | 18 股票符号 日期 最后价 跌幅 百分比
AAR, 20110520, 24.4999, -0.1624, -0.7
AAUKY, 20110520, 23.8300, -0.0513, -0.2
AAWW, 20110520, 63.9700, -1.4313, -2.2
AAXJ, 20110520, 62.6625, -0.3633, -0.6
AB, 20110520, 21.5300, -0.0545, -0.3
ABAX, 20110520, 30.8500, -1.4335, -4.6
ABB, 20110520, 26.3200, -0.0229, -0.1
ABCO, 20110520, 50.9300, -0.4103, -0.8
ABFS, 20110520, 25.3500, -0.7916, -3.1
ABW-A, 20110520, 25.2... 阅读全帖 |
|
v****e
发帖数: 57 | 19 ☆─────────────────────────────────────☆
ldf (3721) 于 (Thu Dec 15 02:16:00 2005) 提到:
I will be in Boston between Dec 27 and 29 and then heading for New York. Could
anybody tell me how to buy train tickets from Boston to NY? How much and
where (website/location)? Peak time traveling, I am wondering whether there
is the risk for seats solding out if I am only buying the tickets at that day.
Thanks a lot.
☆─────────────────────────────────────☆
Backspace (落拓江湖载酒行) 于 (Thu Dec 15 02:25:46 20 |
|
x*7
发帖数: 11281 | 20 今天去turners摸了实枪，感觉不错，做工还是典型的
mossberg，不指望太精细，上面那些明晃晃的油到处都是
除了一个safety和一个bolt release之外，没有找到其他
的按钮/拨杆/啰嗦，应该操作起来不是那么的繁琐
瞄具感觉不错，LDF made in ITALY
gun |
|
|
G*********o
发帖数: 49669 | 22 WO KAOKAOKAOKAOKAOKAOAKAOAKAOAAKKAOAKAKAJAOJAOAJAJDASDFASLF
ALSDFJA;SDFJAS;DFJ ALSDFJLSGHLSDFJAS;LDF
怎们能让北兄失望呢。。 |
|
h*****l
发帖数: 184 | 23 【 以下文字转载自 Software 讨论区,原文如下 】
发信人: hanibal (ganggang), 信区: Software
标 题: Re: SQL下如何转移tempdb
发信站: The unknown SPACE (Tue May 2 17:31:56 2000) WWW-POST
In SQL Server 7, tempdb is the only database that you can
move using the
ALTER DATABASE command:
ALTER DATABASE tempdb
MODIFY FILE (
Name = 'tempdev', Filename = 'newpath/tempdb.mdf)
ALTER DATABASE tempdb
MODIFY FILE (
Name = 'templog', Filename = 'newpath/templog.ldf)
The changes will not take effect until the SQL Server is
restarted. |
|
c******n
发帖数: 6 | 24 Thank you so much for you guys' help! I detached the database and directly
copy the mdf and log.ldf to the data folder of another sql server. seems
working well :-).
Chris
[dbname].MDF
in
domain
tried |
|
a*****a
发帖数: 438 | 25 not ridiculous, if you have tons of transactions.
have you tried DBCC sth.. |
|
d******o
发帖数: 115 | 26 Ok, Calvin, here is your answer:
First of all which version of SQL you have?
You can do DBCC SHRINKDATABASE first ( note it is not DBCC ShrinkDB)
Then do a full backup
Then do DBCC SHRINKFILE
Then you should be fine.
For later maintainence, you can run backup log every 30 minutes +/- depends
your transaction load, and it should keep you log small.
David Gao
MCSE, MCDBA
setting
log |
|
D****N
发帖数: 430 | 27 sure, u can create a blank database, then run..
sp_attach_db dbname, "dbname.mdf", "dbname.ldf" |
|
s******n
发帖数: 45 | 28 Basically u r intested in "audit". The log file won't be easy to look into,
but there are tools out there that can help u do that. One of them is as
follows:
http://www.sql-server-performance.com/lockwoodtech_log_navigator_spotlight.asp
Btw, an earlier post told u about the errorlog, which is not the log u r
looking for. The right one is in ....\mssql\data\[database name]_log.ldf |
|
l*****a
发帖数: 166 | 29 可以用detach and reattach. detach后可以拷贝mdf and ldf file to anywhere. |
|
B*********L
发帖数: 700 | 30 解决了。
1. Move tempdb files to new location(ramdisk).
USE master;
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev, FILENAME = '{new location}\tempdb.mdf');
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = templog, FILENAME = '{new location}\templog.ldf');
GO
2. after reboot machine, new tempdb files are re-created to the ramdisk. |
|
n********6
发帖数: 1511 | 31 谁能给个链接讲解一下user access to system database file (master.mdf,
masterlog.ldf, ...)。
如果用account1装了sql server，能否把account1的access去掉？
用cacl 的时候，可否针对具体的user? google到的例子都是不是针对一个具体的user
，而是针对一个role如“Power Users”。
admin干哪些活的时候需要从file directory访问这些文件？没有从file directory访
问这些文件的权限，是否影响其用studio做admin的活？
谢谢。 |
|
T*******x
发帖数: 8565 | 32
你说的这些，一年能弄明白我看就算快的了。
我就用过一点servlet.
想起以前搞电脑的时候，看文档，看到无穷多的缩写:EJB,DOM,IDL,SLE,LDF,...后面几
个都是我乱敲的，基本上你随便敲3个字母就是一个或多个框架的缩写。呵呵。crazy啊
。后来我看到缩写就头大。这是电脑行业里面一个很不好的现象。其实应该把这些缩写
还原成原来的名字。这样看文档还能亲切一些，说不定能懂得更快一点。 |
|
h*****l
发帖数: 184 | 33 In SQL Server 7, tempdb is the only database that you can
move using the
ALTER DATABASE command:
ALTER DATABASE tempdb
MODIFY FILE (
Name = 'tempdev', Filename = 'newpath/tempdb.mdf)
ALTER DATABASE tempdb
MODIFY FILE (
Name = 'templog', Filename = 'newpath/templog.ldf)
The changes will not take effect until the SQL Server is
restarted. |
|
k********y
发帖数: 27 | 34 小弟正在实习，产险的。遇到了一个project，其中一个book of business里面的一个
line是liability的，在选loss development factor的时候，就是那个loss三角形里面
的数据不充足，接近三分之一是没有loss的，也就导致了数据的缺失。给位牛人们谁知
道遇到这种情况的时候该用什么方法选出LDF？先谢谢啦！ |
|
I**R
发帖数: 1309 | 35 no incurred loss at all?
in this case, you can still select your ldf using the info available,
but try to avoid C-L method when estimating your ultimate loss.
search the cas website, and you'll find a lot of methods to use. |
|
s*******0
发帖数: 3461 | 36 ibnr版大是专家 我等着看回答啊
你的问题看的不是很明白啊 每一年的ratio算出来 最终的ratio当然需要全部乘起来
能不能在说的通俗点啊
ldf 应该是每一年的损失比率吧？ 就是说每一年比上年的损失比率的均值，最终的损失应该要吧因子乘起来
看你的描述应该是用的BF法则，先估计出最终的损失，然后再除以发展因子来估计未决赔款准备金吧。但是发展因子还是需要每年的乘起来，这个不会变的。 |
|
e*******c
发帖数: 2133 | 37 你说的是age to age ldf，算cumulative肯定得都乘起来，然后取倒数应该就是report
%对吧？但是我看到的好像是取完倒数了，在cumulatively multiply一下，非常困惑
这事啊
损失应该要吧因子乘起来
决赔款准备金吧。但是发展因子还是需要每年的乘起来，这个不会变的。 |
|
e*******c
发帖数: 2133 | 38 在health 里也一样，reserve=incurred loss-paid loss,但是incurred loss=paid
loss*（ATU LDF),这样的话incurred loss其实是取决于paid loss的，我不知道在p&c
里是否也是一样 |
|
