a*******t
发帖数: 891 | 1 wah, 這種 cow 人 很難找 ba...
I know certain few cow people on this board can qualify, but those cows are
not common... |
|
c*****d
发帖数: 6045 | 2 双修容易
都要精通就太难了
我是3修, oracle, ms sql, mysql
不过都不精通,哈哈 |
|
c*******t
发帖数: 55 | 3 1. Bulk Insert is faster than SSIS if you turn on the table lock.
2. If you can make the data in all files are sorted, you can save the time
on index rebuild.
3. No matter Simple Recovery or Bulk Mode, SQL Server will start writing
huge data to log file after the first file, the size usually be 2~3 times
the data you are importing, so I suggest you shrink the log file after each
bulk-insert each file. (MSSQL will not write too much data to the log file
if the table is empty) |
|
l****u
发帖数: 84 | 4
不好意思，我没有表达清楚。
第一，是要在MySQL下，不是在MSSQL下面。
第二，我要读的不是mysql.txt 里面的内容，要读的是文件的名称，就是“mysql"
多谢回复 |
|
a*******t
发帖数: 891 | 5 3
key is for data intergurity, make sure every row can be indentified by a
value
google the difference between primary key and unique key
index is for searching |
|
|
B*********L
发帖数: 700 | 7 Thank you to both of you |
|
c*****d
发帖数: 6045 | 8 在mysql里有一个系统表user
里面有哪个用户允许从哪里登录
desc user;
Field |
|
|
|
j*****n
发帖数: 1781 | 11 check your SQL Server Surface Area Configuration, make sure your Remote
Connections are turned on. |
|
a*******t
发帖数: 891 | 12 I think it's very benefitical to know all the popular systems
I've seen quite a few job postings asking for 3 yr Oracle, 3 yr MSSQL, 3 yr
MySQL or something like that. |
|
v***e
发帖数: 2108 | 13 I really doubt it would happen. MySQL does not compete directly with Oracle
RDBMS in some sense, it competes more with MS SQL.
After mysql's reunion with InnoDB in Oracle,
it could be a better weapon against mssql. |
|
v***e
发帖数: 2108 | 14 this does not make sense to me. Now mysql/innodb belongs to Oracle,
it could be a weapon against mssql much more powerful than
any existent Oracle products, isn't enough to keep it?
the business decision is not as simple as you thought.
if your logic holds, the innoDB would have been killed long time ago. |
|
v***e
发帖数: 2108 | 15 不知道国内的行情是怎么样的，除了oracle/db2/mssql/mysql/teradata之类的，
中国有自己的数据库产品吗？ 市场竞争力如何？ 有谁知道的说说。谢谢 |
|
j*****n
发帖数: 1781 | 16 I'd try to use numeric data type or simply varchar type for this field on
sql server. |
|
B*********L
发帖数: 700 | 17 Thanks. it is a index column. I was using bigint type. i'll try numeric or
vachar. |
|
B*********L
发帖数: 700 | 18 it works now. instead of create/edit data flow tasks in an old ssis package.
i create a new ssis package, then everything works fine. |
|
B*********L
发帖数: 700 | 19 下面这个query（其中B是个长公式），column3 就是 column1 乘以 column2，
SQL server总是给我0.
SELECT
A
,POWER(cast(10 as dec(38,20)),B)
,A*POWER(cast(10 as dec(38,20)),B)
FROM TABLE_A
result:
8694 0.00000000003548134000 0.00000000000000000000
2103 0.00000000003981072000 0.00000000000000000000
对column3，我试过以下几种办法，都不行。
,CAST(A as dec(38,20))*POWER(cast(10 as dec(38,20)),B)
,CAST(A as dec(38,20))*CAST(A POWER(cast(10 as dec(38,20)),B) as dec(38,20))
,CAST(CAST(A as dec(38,20))*CAST(A POWER(cast(10 as dec(38,20)), |
|
B*********L
发帖数: 700 | 20
Solved:
cast(A as float)*POWER(cast(10 as dec(38,20)),B) |
|
j*****n
发帖数: 1781 | 21 you probably want do the CAST(A as dec(38,20)) as well. Since converting to
float may give you some exceptional numbers. Just my 2 cents. |
|
B*********L
发帖数: 700 | 22 Thanks.
I don't know why, but CAST(A as dec(38,20)) gives me 0.00000000000
Only float works.
to |
|
m******9
发帖数: 104 | 23 I am new to MSSQL. Can anyone tell me how to backup a single table? It is
system table msdb. I'll need to backup few table from msdb.
Thank you |
|
|
m**v
发帖数: 373 | 25 当然，本地是好的。但是hosting的环境有可能不太一样。。。
有什么别的办法测测performance吗？ |
|
i****a
发帖数: 36252 | 26 if you can't even make a DB connecting to the hosting DB, I doubt you have
permission to do anything much
normal approaches are to run sql profiler, look at DM to find expensive
queries, look at query or cached executing plan, recompile stored procs
etc |
|
m**v
发帖数: 373 | 27 query analyzer是可以连接上的。但是一些有关performance的sql就没有权利执行。 |
|
i****a
发帖数: 36252 | 28 do you have control on your web tier code? try to narrow down to which
section/function is slow, then study that on local environment. |
|
m******9
发帖数: 104 | 29 How to pinpoint performance bottlenecks? For MSSQL, we can use profiles to
analysis it. |
|
B*********L
发帖数: 700 | 30 我的server每小时发一批email。今天断断续续有好几个小时不发不出去了。看log是这
么说的：
The mail could not be sent to the recipients because of the mail server
failure.
我想发个test mail但是send test email变成灰色的，不让click了。
大家有什么建议没有？谢谢 |
|
i****a
发帖数: 36252 | 31 is it using smtp mail server? check the server |
|
B*********L
发帖数: 700 | 32
The smtp mail server has an issue. My database server don't have any problem
. The database email service is back to normal now.
Thanks. |
|
|
j*****n
发帖数: 1781 | 34 I got this message when opening the link...
We're sorry, the page you requested was not found.
btw, I have tried a free version for MSSQL, it only does the basic
functionality. No reverse engineering, which is the most wanted. I doubt
this one is the same. |
|
i****a
发帖数: 36252 | 35 本板就有幾個
我日常工作用 M$$QL, 最近在上 Oracle DBA 課, 發現如果我想兩邊都牛, 要學幾乎一倍
的東西.
Database 方面還好, 還可熔會換通, 但加上 OS difference, shell scripting,
SQL*Loader 等等就開始不消化了 |
|
g***l
发帖数: 18555 | 36 一个搞熟了就有的是饭吃了，就怕两个都是半瓶子醋，你给人说两个都熟，没有人信的
，没有公司两家都用的，两个都用的可能是医院学校啥的，光SQL SERVER一个版本一个
版本的出，根本就跟不上，64BIT MULTISITES CLUSTERING加MIRRORING加REPLICATION,看着头都大，
明年再出2010，又要跟着忙活了。我觉得把一个搞熟，争取去微软镀镀金，考个MVP，我看好多
MVP都是老印啊，其实也不难的。
一倍 |
|
i****a
发帖数: 36252 | 37 其中一個原因是求知欲. 當然更大的原因是想要打入 oracle 圈子, 工資更高... haa
REPLICATION,看
着头都大，
，我看好多 |
|
g***l
发帖数: 18555 | 38 ORACLE DBA没有经验找不到工作的，十年前就断了这个念头，只能去做DEVELOPER，现
在DEVELOPER越来越不值钱，而且OUTSOURCE的厉害，好像印度人一小时几块钱就干，比
INTERN还便宜，没天理啊。DELL, UPS,DISNEY,BARNS NOBEL,发现好多公司都用SQL
SERVER的，关键自己的技术要牛，没有实际经验的话，理论上也要夸夸其谈，一是搞
INFRASTRUCURE+PERFORMANCE TUNING PRODUCTION DBA,一个是搞DATA ARCHITECT，三是
BUSINESS INTELLIGENCE DATAWAREHOUSE,实在不行再去做DEVELOPER.要想走ORACLE路线
，如果有身份可以进机构政府学校先干着，攒点经验再出来做DBA.
haa |
|
i****a
发帖数: 36252 | 39 "本板就有幾個"
自覺點, 進來介紹介紹經驗. 不然我點名拉 |
|
a****b
发帖数: 489 | 40 Oracle DBA的门槛确实是高些，有时候我也纳闷那些人是怎么起步做oracle的dba的。 |
|
B*****g
发帖数: 34098 | 41 高啥呀，咱公司的DBA就run script就行了 |
|
|
|
|
|
|
|
a****e
发帖数: 9589 | 48 就是，我们公司的DBA都不会写script，每次写好了给他们，还得等2礼拜。真不知道
DBA 到底是干什么。 |
|
y****w
发帖数: 3747 | 49 好的dba真的可以make everyting difference。
看我们那个阿三dba干活就很郁闷，nnd的没啥条理，东一榔头西一棒槌，做app dba吧
连ddl都管理不起来，得让developer们把一个个需要的table和index的ddl都上传到vss
。 丫一*nix下的dba居然完全依靠questcentral工作，基本脚本写不了；难怪领导放着
他在这巴巴的contr着然后一直在招permanent，就是不给丫机会啊。 |
|
y****w
发帖数: 3747 | 50 dba不会写script相当于严重残废啊，尤其是*nix下工作的dba,sys admin们， |
|
