|
n******7
发帖数: 12463 | 2 mbp的键盘上没有这几个键（delete其实相当于win／linux下的backspace）
还是觉得不爽
现在想买个外接键盘，不知到用pc的键盘 这几个键会不会起作用？
我记得以前mac没有右键的时候 pc的双键鼠标还是可以正常工作的。 |
|
j****n
发帖数: 4358 | 3 Just got a new one
donot know how to delete pics in photos
thanks |
|
f********1
发帖数: 698 | 4 just deleted recent calls by accident and found there was a missed call...
how can i know what number it was? i checked att and it just showed the
calls of last month...help! |
|
|
v**********s
发帖数: 125 | 6 手指滑过你要删除的文件，文件名右边就会出现delete |
|
w********1
发帖数: 3492 | 7 Tue, 26 Jun 2012 11:18:14 PDT
A volunteer team has been downloading the entire publicly accessible
contents of MobileMe webpages, iDisk folders, and photo galleries, ahead of
the shutdown of the MobileMe service on June 30.
The team just finished the project, some four days ahead of their deadline.
The project began late last yearn and ramped up as the team moved closer to
the MobileMe shutdown date.
Archive Team has finished downloading MobileMe and .Mac before Apple deletes
it on June 30. 272 ... 阅读全帖 |
|
F****3
发帖数: 1504 | 8 我主要是买了以后在Win 7环境下使用。请问应该怎样才能使用delete键盘呢？ |
|
N*******3
发帖数: 2589 | 9
左下角Fn+右上那个Delete就行了。前提是你装了bootcamp的驱动。
这个版的名声有时候就是被不好好回答别人问题的人弄坏的。虽然有时候只是开玩笑而
已。。。 |
|
s******y
发帖数: 522 | 10 Fn + delete 不管用
需要装什么驱动或者键盘映射吗 |
|
s*****a
发帖数: 152 | 11 Does anyone know how to delete those ads stuff in the registry in Windows? I
have ad-aware, but it couldn't get rid of all those ads. Does anyone know a
better software which can scan more deeply? Thanks a lot. |
|
f**y
发帖数: 138 | 12 Can you move other files away and then delete the folder? |
|
T******y
发帖数: 14506 | 13 It occupies too much space, wanna delete it and release some space.
Thanks!!! |
|
a***h
发帖数: 29 | 14 how to delete log
on "Restore database" popup panel, there are three radio
choices: "database", "filegroups or files", and "from
device". when choosing "database" or "filegroups or files",
it shows the backup history. what should i do if i don't
want to see such backup history? |
|
w*g
发帖数: 413 | 15 other talbes have foreign key referrence to some attribute of this table. So if
I just use delete from...,I will get a msg like this:
ORA-02292: integrity constraint (WGUAN.SYS_C0061954) violated - child
record found
I tried to drop the foreign key in those tables using:
DROP FOREIGN KEY (***) REFENERRENCES tablename (**)
error msg:
ORA-00905: missing keyword
What should I do? Thanks. |
|
b****e
发帖数: 1275 | 16 i want to delete a whole database in ddl (my db is cloudscape..
which has no GUI based admin tools)
how do i do that in ddl?
thanks |
|
g******p
发帖数: 18 | 17 Hi,
I have Oracle Personal Edition on Win98. At the time I set
it up, I somehow set up the SID twice, now I am having
problem, either ASP or Java code that calls the database
will sometimes(not always) caused error when starting up the
database, an error message box for ostart.exe.
I wonder if I just delete one of the SID will work but don't
know how to do that.
Any help is appreciated. |
|
g******p
发帖数: 18 | 18 I found Oralce Database Configuration Assistant which
can delete a database, which is just what I want.
Unfortunately, it prompts me to enter INTERNAL
password, I remember when installing the database, it
showed up as hidden:******, does anyone know what this
password is? |
|
ak
发帖数: 512 | 19 How to delete column and row in table (oracle)?
I am a new user. Thanks! |
|
d****o
发帖数: 3 | 20 有两个table，
table1有ID, Descr两个字段， 其中ID为unique key
table2有ID1, ID2和其他一些字段，其中ID1，ID2都是从table1的ID来的，
想要talbe1.ID有delete, update的时候table2中的ID1, ID2会相应更新，
缺做不了，说会有may cause cycles or multiple cascade paths.
请问，应该怎样解决这个问题呀？
多谢 |
|
c**t
发帖数: 2744 | 21 SQL Server:
truncate table blah
vs
delete blah
which one is faster? and why? |
|
a*******t
发帖数: 41 | 22 Hi,
I can do this in sql server -
select * where cln1 like '%(%)%'
however, if I want to delete the characters between parentheses, I can't use
replace( cln1, '(%)','').
Anyone knows how to do it?
Thanks a lot! |
|
I******e
发帖数: 101 | 23 depending on whether ms is doing deferred delete. most dbms are doing it. |
|
j***a
发帖数: 10844 | 24 And truncate will release the storage space. Delete won't. |
|
n********6
发帖数: 1511 | 25 补充题外问题：
在sql server里面，如果在stored procedure里面用truncate，job agent run需要非
常高的权限。为什么呢？因为truncate是DDL吗？
结果是：很多都用delete，尽管有些数据可能不需要写入log file。 |
|
k*******1
发帖数: 22 | 26 "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 |
|
g***l
发帖数: 18555 | 29 那还是
DELETE A
FROM ABC A
WHERE NOT EXIST()
这样吧 |
|
b**a
发帖数: 1118 | 30 Now we can only delete them in 1 hour. How to make it in 30 mins?
Thanks,
Ming |
|
b**a
发帖数: 1118 | 31 发信人: Beijing (中国万岁，北京加油), 信区: Database
标 题: Re: How to delete 40 millions records in a 400 millions indexe
发信站: BBS 未名空间站 (Tue Jan 24 17:58:08 2012, 美东)
what database? sql server 2008
which version?
table partitioned? no
any audit/archive is using? no idea...
【 在 buaa (ming) 的大作中提到: 】 |
|
b**a
发帖数: 1118 | 32 I am using sth like this now:
DECLARE @count2 int
SET @count2 = 10000
WHILE @count2 >= 10000
BEGIN
DELETE temp from ( SELECT TOP 10000 * FROM Transactions WITH(NOLOCK)
WHERE TransStartTime >= @FromDate and TransStartTime < @EndDate)
temp OPTION (MAXDOP 1)
SELECT @count2 = @@ROWCOUNT
END
and i really need it to run faster... |
|
i****a
发帖数: 36252 | 33 Do a larger batch than 10k should help. And just do delete without the sub
select.m
Are your lookup parameters indexed?
And what's the purpose of (MAXDOP 1)?
)
[发表自未名空间手机版 - m.mitbbs.com] |
|
|
i****a
发帖数: 36252 | 35 Try with just delete top 100000 from tbl where ....
a
[发表自未名空间手机版 - m.mitbbs.com] |
|
c*****d
发帖数: 6045 | 36 同时run 10个，每个delete 4 millions record?
这个方法性能更慢 |
|
y****w
发帖数: 3747 | 37 并发delete总是要受影响的吧。各个并发之间必须有严格的界限，不然以set的无序特
性，跑跑就锁死了，或操作旧数据了。
lz这个没table partition，用partition/order by硬排序出来或许行，用rank避免最
后那组值的随机性.
没注意sql 2008支持不支持类似currently committed语义。 |
|
c*****d
发帖数: 6045 | 38 我没搞清楚lz是必须用sql delete的方法来删除
还是可以用其他方法来实现？ |
|
b**a
发帖数: 1118 | 39 发信人: Beijing (中国万岁，北京加油), 信区: Database
标 题: Re: How to delete 40 millions records in a 400 millions indexe
发信站: BBS 未名空间站 (Tue Jan 24 17:58:08 2012, 美东)
what database? sql server 2008
which version?
table partitioned? no
any audit/archive is using? no idea...
【 在 buaa (ming) 的大作中提到: 】 |
|
b**a
发帖数: 1118 | 40 I am using sth like this now:
DECLARE @count2 int
SET @count2 = 10000
WHILE @count2 >= 10000
BEGIN
DELETE temp from ( SELECT TOP 10000 * FROM Transactions WITH(NOLOCK)
WHERE TransStartTime >= @FromDate and TransStartTime < @EndDate)
temp OPTION (MAXDOP 1)
SELECT @count2 = @@ROWCOUNT
END
and i really need it to run faster... |
|
i****a
发帖数: 36252 | 41 Do a larger batch than 10k should help. And just do delete without the sub
select.m
Are your lookup parameters indexed?
And what's the purpose of (MAXDOP 1)?
)
[发表自未名空间手机版 - m.mitbbs.com] |
|
|
i****a
发帖数: 36252 | 43 Try with just delete top 100000 from tbl where ....
a
[发表自未名空间手机版 - m.mitbbs.com] |
|
c*****d
发帖数: 6045 | 44 同时run 10个，每个delete 4 millions record?
这个方法性能更慢 |
|
y****w
发帖数: 3747 | 45 并发delete总是要受影响的吧。各个并发之间必须有严格的界限，不然以set的无序特
性，跑跑就锁死了，或操作旧数据了。
lz这个没table partition，用partition/order by硬排序出来或许行，用rank避免最
后那组值的随机性.
没注意sql 2008支持不支持类似currently committed语义。 |
|
c*****d
发帖数: 6045 | 46 我没搞清楚lz是必须用sql delete的方法来删除
还是可以用其他方法来实现？ |
|
g***l
发帖数: 18555 | 47 没有INDEX不删的更慢么，DELETE WHERE上要有INDEX，然后BATCH的删 |
|
c*****d
发帖数: 6045 | 48 rman nocatalog
{
backup as backupset database;
backup as backupset archivelog all not backed up;
}
假如现在有10天的backup of database和10天的backup of archivelog
还有10天的archivelog
现在用delete obsolete，retention policy是1天
rman会删除？
a.前9天的backup of database
b.前9天的backup of database+前9天的backup of archivelog
c.前9天的backup of database+前9天的backup of archivelog+前9天的archivelog |
|
r****y
发帖数: 26819 | 49 delete in solution explorer |
|
d*r
发帖数: 238 | 50 right click and choose delete |
|
